DatabaseTableAccessEntry¶

class oci.data_safe.models.DatabaseTableAccessEntry(**kwargs)¶

Bases: object

A DatabaseTableAccess is a resource corresponding to a row in database table access report. It contains information about user’s privilege grants that enable table access for the user. It’s a subresource of Security Policy Report resource and is always associated with a SecurityPolicyReport.

Attributes

`ACCESS_TYPE_DELETE`	A constant which can be used with the access_type property of a DatabaseTableAccessEntry.
`ACCESS_TYPE_INSERT`	A constant which can be used with the access_type property of a DatabaseTableAccessEntry.
`ACCESS_TYPE_OWNER`	A constant which can be used with the access_type property of a DatabaseTableAccessEntry.
`ACCESS_TYPE_SELECT`	A constant which can be used with the access_type property of a DatabaseTableAccessEntry.
`ACCESS_TYPE_UPDATE`	A constant which can be used with the access_type property of a DatabaseTableAccessEntry.
`PRIVILEGE_CREATE_ANY_INDEX`	A constant which can be used with the privilege property of a DatabaseTableAccessEntry.
`PRIVILEGE_DELETE`	A constant which can be used with the privilege property of a DatabaseTableAccessEntry.
`PRIVILEGE_DELETE_ANY_TABLE`	A constant which can be used with the privilege property of a DatabaseTableAccessEntry.
`PRIVILEGE_GRANTABLE_ADMIN_OPTION`	A constant which can be used with the privilege_grantable property of a DatabaseTableAccessEntry.
`PRIVILEGE_GRANTABLE_GRANT_OPTION`	A constant which can be used with the privilege_grantable property of a DatabaseTableAccessEntry.
`PRIVILEGE_INDEX`	A constant which can be used with the privilege property of a DatabaseTableAccessEntry.
`PRIVILEGE_INSERT`	A constant which can be used with the privilege property of a DatabaseTableAccessEntry.
`PRIVILEGE_INSERT_ANY_TABLE`	A constant which can be used with the privilege property of a DatabaseTableAccessEntry.
`PRIVILEGE_OWNER`	A constant which can be used with the privilege property of a DatabaseTableAccessEntry.
`PRIVILEGE_READ`	A constant which can be used with the privilege property of a DatabaseTableAccessEntry.
`PRIVILEGE_READ_ANY_TABLE`	A constant which can be used with the privilege property of a DatabaseTableAccessEntry.
`PRIVILEGE_SELECT`	A constant which can be used with the privilege property of a DatabaseTableAccessEntry.
`PRIVILEGE_SELECT_ANY_TABLE`	A constant which can be used with the privilege property of a DatabaseTableAccessEntry.
`PRIVILEGE_UPDATE`	A constant which can be used with the privilege property of a DatabaseTableAccessEntry.
`PRIVILEGE_UPDATE_ANY_TABLE`	A constant which can be used with the privilege property of a DatabaseTableAccessEntry.
`access_through_object`	Gets the access_through_object of this DatabaseTableAccessEntry.
`access_type`	Gets the access_type of this DatabaseTableAccessEntry.
`are_all_tables_accessible`	Gets the are_all_tables_accessible of this DatabaseTableAccessEntry.
`column_name`	Gets the column_name of this DatabaseTableAccessEntry.
`grant_from_role`	Gets the grant_from_role of this DatabaseTableAccessEntry.
`grantee`	Gets the grantee of this DatabaseTableAccessEntry.
`grantor`	Gets the grantor of this DatabaseTableAccessEntry.
`is_access_constrained_by_database_vault`	Gets the is_access_constrained_by_database_vault of this DatabaseTableAccessEntry.
`is_access_constrained_by_label_security`	Gets the is_access_constrained_by_label_security of this DatabaseTableAccessEntry.
`is_access_constrained_by_real_application_security`	Gets the is_access_constrained_by_real_application_security of this DatabaseTableAccessEntry.
`is_access_constrained_by_redaction`	Gets the is_access_constrained_by_redaction of this DatabaseTableAccessEntry.
`is_access_constrained_by_sql_firewall`	Gets the is_access_constrained_by_sql_firewall of this DatabaseTableAccessEntry.
`is_access_constrained_by_view`	Gets the is_access_constrained_by_view of this DatabaseTableAccessEntry.
`is_access_constrained_by_virtual_private_database`	Gets the is_access_constrained_by_virtual_private_database of this DatabaseTableAccessEntry.
`is_sensitive`	Gets the is_sensitive of this DatabaseTableAccessEntry.
`key`	[Required] Gets the key of this DatabaseTableAccessEntry.
`privilege`	Gets the privilege of this DatabaseTableAccessEntry.
`privilege_grantable`	Gets the privilege_grantable of this DatabaseTableAccessEntry.
`privilege_type`	Gets the privilege_type of this DatabaseTableAccessEntry.
`table_name`	Gets the table_name of this DatabaseTableAccessEntry.
`table_schema`	Gets the table_schema of this DatabaseTableAccessEntry.
`target_id`	Gets the target_id of this DatabaseTableAccessEntry.

Methods

__init__(**kwargs) Initializes a new DatabaseTableAccessEntry object with values from keyword arguments.

ACCESS_TYPE_DELETE = 'DELETE'¶: A constant which can be used with the access_type property of a DatabaseTableAccessEntry. This constant has a value of “DELETE”

ACCESS_TYPE_INSERT = 'INSERT'¶: A constant which can be used with the access_type property of a DatabaseTableAccessEntry. This constant has a value of “INSERT”

ACCESS_TYPE_OWNER = 'OWNER'¶: A constant which can be used with the access_type property of a DatabaseTableAccessEntry. This constant has a value of “OWNER”

ACCESS_TYPE_SELECT = 'SELECT'¶: A constant which can be used with the access_type property of a DatabaseTableAccessEntry. This constant has a value of “SELECT”

ACCESS_TYPE_UPDATE = 'UPDATE'¶: A constant which can be used with the access_type property of a DatabaseTableAccessEntry. This constant has a value of “UPDATE”

PRIVILEGE_CREATE_ANY_INDEX = 'CREATE_ANY_INDEX'¶: A constant which can be used with the privilege property of a DatabaseTableAccessEntry. This constant has a value of “CREATE_ANY_INDEX”

PRIVILEGE_DELETE = 'DELETE'¶: A constant which can be used with the privilege property of a DatabaseTableAccessEntry. This constant has a value of “DELETE”

PRIVILEGE_DELETE_ANY_TABLE = 'DELETE_ANY_TABLE'¶: A constant which can be used with the privilege property of a DatabaseTableAccessEntry. This constant has a value of “DELETE_ANY_TABLE”

PRIVILEGE_GRANTABLE_ADMIN_OPTION = 'ADMIN_OPTION'¶: A constant which can be used with the privilege_grantable property of a DatabaseTableAccessEntry. This constant has a value of “ADMIN_OPTION”

PRIVILEGE_GRANTABLE_GRANT_OPTION = 'GRANT_OPTION'¶: A constant which can be used with the privilege_grantable property of a DatabaseTableAccessEntry. This constant has a value of “GRANT_OPTION”

PRIVILEGE_INDEX = 'INDEX'¶: A constant which can be used with the privilege property of a DatabaseTableAccessEntry. This constant has a value of “INDEX”

PRIVILEGE_INSERT = 'INSERT'¶: A constant which can be used with the privilege property of a DatabaseTableAccessEntry. This constant has a value of “INSERT”

PRIVILEGE_INSERT_ANY_TABLE = 'INSERT_ANY_TABLE'¶: A constant which can be used with the privilege property of a DatabaseTableAccessEntry. This constant has a value of “INSERT_ANY_TABLE”

PRIVILEGE_OWNER = 'OWNER'¶: A constant which can be used with the privilege property of a DatabaseTableAccessEntry. This constant has a value of “OWNER”

PRIVILEGE_READ = 'READ'¶: A constant which can be used with the privilege property of a DatabaseTableAccessEntry. This constant has a value of “READ”

PRIVILEGE_READ_ANY_TABLE = 'READ_ANY_TABLE'¶: A constant which can be used with the privilege property of a DatabaseTableAccessEntry. This constant has a value of “READ_ANY_TABLE”

PRIVILEGE_SELECT = 'SELECT'¶: A constant which can be used with the privilege property of a DatabaseTableAccessEntry. This constant has a value of “SELECT”

PRIVILEGE_SELECT_ANY_TABLE = 'SELECT_ANY_TABLE'¶: A constant which can be used with the privilege property of a DatabaseTableAccessEntry. This constant has a value of “SELECT_ANY_TABLE”

PRIVILEGE_UPDATE = 'UPDATE'¶: A constant which can be used with the privilege property of a DatabaseTableAccessEntry. This constant has a value of “UPDATE”

PRIVILEGE_UPDATE_ANY_TABLE = 'UPDATE_ANY_TABLE'¶: A constant which can be used with the privilege property of a DatabaseTableAccessEntry. This constant has a value of “UPDATE_ANY_TABLE”

__init__(**kwargs)¶

Initializes a new DatabaseTableAccessEntry object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

key (str) – The value to assign to the key property of this DatabaseTableAccessEntry.
grantee (str) – The value to assign to the grantee property of this DatabaseTableAccessEntry.
access_type (str) – The value to assign to the access_type property of this DatabaseTableAccessEntry. Allowed values for this property are: “SELECT”, “UPDATE”, “INSERT”, “DELETE”, “OWNER”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
table_schema (str) – The value to assign to the table_schema property of this DatabaseTableAccessEntry.
table_name (str) – The value to assign to the table_name property of this DatabaseTableAccessEntry.
privilege_type (str) – The value to assign to the privilege_type property of this DatabaseTableAccessEntry.
target_id (str) – The value to assign to the target_id property of this DatabaseTableAccessEntry.
privilege (str) – The value to assign to the privilege property of this DatabaseTableAccessEntry. Allowed values for this property are: “SELECT”, “UPDATE”, “INSERT”, “DELETE”, “READ”, “OWNER”, “INDEX”, “SELECT_ANY_TABLE”, “UPDATE_ANY_TABLE”, “INSERT_ANY_TABLE”, “DELETE_ANY_TABLE”, “READ_ANY_TABLE”, “CREATE_ANY_INDEX”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
privilege_grantable (str) – The value to assign to the privilege_grantable property of this DatabaseTableAccessEntry. Allowed values for this property are: “ADMIN_OPTION”, “GRANT_OPTION”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
grant_from_role (str) – The value to assign to the grant_from_role property of this DatabaseTableAccessEntry.
access_through_object (str) – The value to assign to the access_through_object property of this DatabaseTableAccessEntry.
column_name (str) – The value to assign to the column_name property of this DatabaseTableAccessEntry.
grantor (str) – The value to assign to the grantor property of this DatabaseTableAccessEntry.
are_all_tables_accessible (bool) – The value to assign to the are_all_tables_accessible property of this DatabaseTableAccessEntry.
is_access_constrained_by_view (bool) – The value to assign to the is_access_constrained_by_view property of this DatabaseTableAccessEntry.
is_access_constrained_by_label_security (bool) – The value to assign to the is_access_constrained_by_label_security property of this DatabaseTableAccessEntry.
is_access_constrained_by_database_vault (bool) – The value to assign to the is_access_constrained_by_database_vault property of this DatabaseTableAccessEntry.
is_access_constrained_by_virtual_private_database (bool) – The value to assign to the is_access_constrained_by_virtual_private_database property of this DatabaseTableAccessEntry.
is_access_constrained_by_redaction (bool) – The value to assign to the is_access_constrained_by_redaction property of this DatabaseTableAccessEntry.
is_access_constrained_by_real_application_security (bool) – The value to assign to the is_access_constrained_by_real_application_security property of this DatabaseTableAccessEntry.
is_access_constrained_by_sql_firewall (bool) – The value to assign to the is_access_constrained_by_sql_firewall property of this DatabaseTableAccessEntry.
is_sensitive (bool) – The value to assign to the is_sensitive property of this DatabaseTableAccessEntry.

access_through_object¶

Gets the access_through_object of this DatabaseTableAccessEntry. A non-null value in this field indicates the object through which user has access to table, possible values could be table or view.

Returns:	The access_through_object of this DatabaseTableAccessEntry.
Return type:	str

access_type¶

Gets the access_type of this DatabaseTableAccessEntry. The type of the access the user has on the table, there can be one or more from SELECT, UPDATE, INSERT, OWNER or DELETE.

Allowed values for this property are: “SELECT”, “UPDATE”, “INSERT”, “DELETE”, “OWNER”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The access_type of this DatabaseTableAccessEntry.
Return type:	str

are_all_tables_accessible¶

Gets the are_all_tables_accessible of this DatabaseTableAccessEntry. Indicates whether the user has access to all the tables in the schema.

Returns:	The are_all_tables_accessible of this DatabaseTableAccessEntry.
Return type:	bool

column_name¶

Gets the column_name of this DatabaseTableAccessEntry. If there are column level privileges on a table or view.

Returns:	The column_name of this DatabaseTableAccessEntry.
Return type:	str

grant_from_role¶

Gets the grant_from_role of this DatabaseTableAccessEntry. 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.

Returns:	The grant_from_role of this DatabaseTableAccessEntry.
Return type:	str

grantee¶

Gets the grantee of this DatabaseTableAccessEntry. Grantee is the user who can access the table

Returns:	The grantee of this DatabaseTableAccessEntry.
Return type:	str

grantor¶

Gets the grantor of this DatabaseTableAccessEntry. The one who granted this privilege.

Returns:	The grantor of this DatabaseTableAccessEntry.
Return type:	str

is_access_constrained_by_database_vault¶

Gets the is_access_constrained_by_database_vault of this DatabaseTableAccessEntry. Indicates whether the table access is constrained via Oracle Database Vault.

Returns:	The is_access_constrained_by_database_vault of this DatabaseTableAccessEntry.
Return type:	bool

is_access_constrained_by_label_security¶

Gets the is_access_constrained_by_label_security of this DatabaseTableAccessEntry. Indicates whether the table access is constrained via Oracle Label Security.

Returns:	The is_access_constrained_by_label_security of this DatabaseTableAccessEntry.
Return type:	bool

is_access_constrained_by_real_application_security¶

Gets the is_access_constrained_by_real_application_security of this DatabaseTableAccessEntry. Indicates whether the table access is constrained via Real Application Security.

Returns:	The is_access_constrained_by_real_application_security of this DatabaseTableAccessEntry.
Return type:	bool

is_access_constrained_by_redaction¶

Gets the is_access_constrained_by_redaction of this DatabaseTableAccessEntry. Indicates whether the table access is constrained via Oracle Data Redaction.

Returns:	The is_access_constrained_by_redaction of this DatabaseTableAccessEntry.
Return type:	bool

is_access_constrained_by_sql_firewall¶

Gets the is_access_constrained_by_sql_firewall of this DatabaseTableAccessEntry. Indicates whether the table access is constrained via Oracle Database SQL Firewall.

Returns:	The is_access_constrained_by_sql_firewall of this DatabaseTableAccessEntry.
Return type:	bool

is_access_constrained_by_view¶

Gets the is_access_constrained_by_view of this DatabaseTableAccessEntry. Indicates whether the access is constrained on a table via a view.

Returns:	The is_access_constrained_by_view of this DatabaseTableAccessEntry.
Return type:	bool

is_access_constrained_by_virtual_private_database¶

Gets the is_access_constrained_by_virtual_private_database of this DatabaseTableAccessEntry. Indicates whether the table access is constrained via Virtual Private Database.

Returns:	The is_access_constrained_by_virtual_private_database of this DatabaseTableAccessEntry.
Return type:	bool

is_sensitive¶

Gets the is_sensitive of this DatabaseTableAccessEntry. Indicates whether the table is marked as sensitive.

Returns:	The is_sensitive of this DatabaseTableAccessEntry.
Return type:	bool

key¶

[Required] Gets the key of this DatabaseTableAccessEntry. The unique key that identifies the table access report. It is numeric and unique within a security policy report.

Returns:	The key of this DatabaseTableAccessEntry.
Return type:	str

privilege¶

Gets the privilege of this DatabaseTableAccessEntry. Name of the privilege.

Allowed values for this property are: “SELECT”, “UPDATE”, “INSERT”, “DELETE”, “READ”, “OWNER”, “INDEX”, “SELECT_ANY_TABLE”, “UPDATE_ANY_TABLE”, “INSERT_ANY_TABLE”, “DELETE_ANY_TABLE”, “READ_ANY_TABLE”, “CREATE_ANY_INDEX”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The privilege of this DatabaseTableAccessEntry.
Return type:	str

privilege_grantable¶

Gets the privilege_grantable of this DatabaseTableAccessEntry. 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

Allowed values for this property are: “ADMIN_OPTION”, “GRANT_OPTION”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The privilege_grantable of this DatabaseTableAccessEntry.
Return type:	str

privilege_type¶

Gets the privilege_type of this DatabaseTableAccessEntry. Type of the privilege user has, this includes System Privilege, Schema Privilege, Object Privilege, Column Privilege, Owner or Schema Privilege on a schema.

Returns:	The privilege_type of this DatabaseTableAccessEntry.
Return type:	str

table_name¶

Gets the table_name of this DatabaseTableAccessEntry. The name of the database table the user has access to.

Returns:	The table_name of this DatabaseTableAccessEntry.
Return type:	str

table_schema¶

Gets the table_schema of this DatabaseTableAccessEntry. The name of the schema the table belongs to.

Returns:	The table_schema of this DatabaseTableAccessEntry.
Return type:	str

target_id¶

Gets the target_id of this DatabaseTableAccessEntry. The OCID of the of the target database.

Returns:	The target_id of this DatabaseTableAccessEntry.
Return type:	str