Class DatabaseViewAccessEntry
A DatabaseViewAccessEntry object is a resource corresponding to a row in view authorization report. It's a subresource of Security Policy Report resource and is always associated with a SecurityPolicyReport.
Inherited Members
Namespace: Oci.DatasafeService.Models
Assembly: OCI.DotNetSDK.Datasafe.dll
Syntax
public class DatabaseViewAccessEntry
Properties
AccessType
Declaration
[JsonProperty(PropertyName = "accessType")]
[JsonConverter(typeof(ResponseEnumConverter))]
public AccessType? AccessType { get; set; }
Property Value
Type | Description |
---|---|
AccessType? | The type of the access the user has on the table, there can be one or more from SELECT, UPDATE, INSERT or DELETE. |
ColumnName
Declaration
[JsonProperty(PropertyName = "columnName")]
public string ColumnName { get; set; }
Property Value
Type | Description |
---|---|
string | If there are column level privileges on a table or view. |
GrantFromRole
Declaration
[JsonProperty(PropertyName = "grantFromRole")]
public string GrantFromRole { get; set; }
Property Value
Type | Description |
---|---|
string | This can be empty in case of direct grant, in case of indirect grant, this attribute displays the name of the role which is granted to the user though which the user has access to the table. |
Grantee
Declaration
[Required(ErrorMessage = "Grantee is required.")]
[JsonProperty(PropertyName = "grantee")]
public string Grantee { get; set; }
Property Value
Type | Description |
---|---|
string | Grantee is the user who can access the table or view |
Remarks
Required
Grantor
Declaration
[JsonProperty(PropertyName = "grantor")]
public string Grantor { get; set; }
Property Value
Type | Description |
---|---|
string | The user who granted the privilege. |
IsAccessConstrainedByDatabaseVault
Declaration
[JsonProperty(PropertyName = "isAccessConstrainedByDatabaseVault")]
public bool? IsAccessConstrainedByDatabaseVault { get; set; }
Property Value
Type | Description |
---|---|
bool? | Indicates whether the table access is constrained via Oracle Database Vault. |
IsAccessConstrainedByRealApplicationSecurity
Declaration
[JsonProperty(PropertyName = "isAccessConstrainedByRealApplicationSecurity")]
public bool? IsAccessConstrainedByRealApplicationSecurity { get; set; }
Property Value
Type | Description |
---|---|
bool? | Indicates whether the view access is constrained via Real Application Security. |
IsAccessConstrainedByRedaction
Declaration
[JsonProperty(PropertyName = "isAccessConstrainedByRedaction")]
public bool? IsAccessConstrainedByRedaction { get; set; }
Property Value
Type | Description |
---|---|
bool? | Indicates whether the view access is constrained via Oracle Data Redaction. |
IsAccessConstrainedBySqlFirewall
Declaration
[JsonProperty(PropertyName = "isAccessConstrainedBySqlFirewall")]
public bool? IsAccessConstrainedBySqlFirewall { get; set; }
Property Value
Type | Description |
---|---|
bool? | Indicates whether the view access is constrained via Oracle Database SQL Firewall. |
IsAccessConstrainedByVirtualPrivateDatabase
Declaration
[JsonProperty(PropertyName = "isAccessConstrainedByVirtualPrivateDatabase")]
public bool? IsAccessConstrainedByVirtualPrivateDatabase { get; set; }
Property Value
Type | Description |
---|---|
bool? | Indicates whether the view access is constrained via Virtual Private Database. |
Key
Declaration
[Required(ErrorMessage = "Key is required.")]
[JsonProperty(PropertyName = "key")]
public string Key { get; set; }
Property Value
Type | Description |
---|---|
string | The unique key that identifies the table access report. It is numeric and unique within a security policy report. |
Remarks
Required
Privilege
Declaration
[JsonProperty(PropertyName = "privilege")]
[JsonConverter(typeof(ResponseEnumConverter))]
public PrivilegeName? Privilege { get; set; }
Property Value
Type | Description |
---|---|
PrivilegeName? | The name of the privilege. |
PrivilegeGrantable
Declaration
[JsonProperty(PropertyName = "privilegeGrantable")]
[JsonConverter(typeof(ResponseEnumConverter))]
public PrivilegeGrantableOption? PrivilegeGrantable { get; set; }
Property Value
Type | Description |
---|---|
PrivilegeGrantableOption? | Indicates whether the grantee can grant this privilege to other users. Privileges can be granted to a user or role with GRANT_OPTION or ADMIN_OPTION |
PrivilegeType
Declaration
[JsonProperty(PropertyName = "privilegeType")]
public string PrivilegeType { get; set; }
Property Value
Type | Description |
---|---|
string | Type of the privilege user has, this includes System Privilege, Schema Privilege, Object Privilege, Column Privilege, Owner or Schema Privilege on a schema. |
TableName
Declaration
[JsonProperty(PropertyName = "tableName")]
public string TableName { get; set; }
Property Value
Type | Description |
---|---|
string | The name of the database table the user has access to. |
TableSchema
Declaration
[JsonProperty(PropertyName = "tableSchema")]
public string TableSchema { get; set; }
Property Value
Type | Description |
---|---|
string | The name of the schema the table belongs to. |
TargetId
Declaration
[JsonProperty(PropertyName = "targetId")]
public string TargetId { get; set; }
Property Value
Type | Description |
---|---|
string | The OCID of the of the target database. |
ViewName
Declaration
[JsonProperty(PropertyName = "viewName")]
public string ViewName { get; set; }
Property Value
Type | Description |
---|---|
string | The name of the view. |
ViewSchema
Declaration
[JsonProperty(PropertyName = "viewSchema")]
public string ViewSchema { get; set; }
Property Value
Type | Description |
---|---|
string | The name of the schema. |
ViewText
Declaration
[JsonProperty(PropertyName = "viewText")]
public string ViewText { get; set; }
Property Value
Type | Description |
---|---|
string | Definition of the view. |