Class DatabaseTableAccessEntrySummary

Summary of DatabaseTableAccessEntry Object.

Inheritance

object

DatabaseTableAccessEntrySummary

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.DatasafeService.Models

Assembly: OCI.DotNetSDK.Datasafe.dll

Syntax

public class DatabaseTableAccessEntrySummary

Properties

AccessThroughObject

Declaration

[JsonProperty(PropertyName = "accessThroughObject")]
public string AccessThroughObject { get; set; }

Property Value

Type	Description
string	A non-null value in this field indicates the object through which user has access to table, possible values could be table or view.

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, OWNER or DELETE.

AreAllTablesAccessible

Declaration

[JsonProperty(PropertyName = "areAllTablesAccessible")]
public bool? AreAllTablesAccessible { get; set; }

Property Value

Type	Description
bool?	Indicates whether the user has access to all the tables in the schema.

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

[JsonProperty(PropertyName = "grantee")]
public string Grantee { get; set; }

Property Value

Type	Description
string	Grantee is the user who can access the table

Grantor

Declaration

[JsonProperty(PropertyName = "grantor")]
public string Grantor { get; set; }

Property Value

Type	Description
string	The one who granted this 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.

IsAccessConstrainedByLabelSecurity

Declaration

[JsonProperty(PropertyName = "isAccessConstrainedByLabelSecurity")]
public bool? IsAccessConstrainedByLabelSecurity { get; set; }

Property Value

Type	Description
bool?	Indicates whether the table access is constrained via Oracle Label Security.

IsAccessConstrainedByRealApplicationSecurity

Declaration

[JsonProperty(PropertyName = "isAccessConstrainedByRealApplicationSecurity")]
public bool? IsAccessConstrainedByRealApplicationSecurity { get; set; }

Property Value

Type	Description
bool?	Indicates whether the table 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 table 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 table access is constrained via Oracle Database SQL Firewall.

IsAccessConstrainedByView

Declaration

[JsonProperty(PropertyName = "isAccessConstrainedByView")]
public bool? IsAccessConstrainedByView { get; set; }

Property Value

Type	Description
bool?	Indicates whether the access is constrained on a table via a view.

IsAccessConstrainedByVirtualPrivateDatabase

Declaration

[JsonProperty(PropertyName = "isAccessConstrainedByVirtualPrivateDatabase")]
public bool? IsAccessConstrainedByVirtualPrivateDatabase { get; set; }

Property Value

Type	Description
bool?	Indicates whether the table access is constrained via Virtual Private Database.

IsSensitive

Declaration

[JsonProperty(PropertyName = "isSensitive")]
public bool? IsSensitive { get; set; }

Property Value

Type	Description
bool?	Indicates whether the table is marked as sensitive.

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?	Name of the privilege.

PrivilegeGrantable

Declaration

[JsonProperty(PropertyName = "privilegeGrantable")]
[JsonConverter(typeof(ResponseEnumConverter))]
public PrivilegeGrantableOption? PrivilegeGrantable { get; set; }

Property Value

Type	Description
PrivilegeGrantableOption?	Whether 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	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	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.