DatabaseTableAccessEntrySummary

class oci.data_safe.models.DatabaseTableAccessEntrySummary(**kwargs)

Bases: object

Summary of DatabaseTableAccessEntry Object.

Attributes:

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

Methods:

__init__(**kwargs)

Initializes a new DatabaseTableAccessEntrySummary object with values from keyword arguments.

ACCESS_TYPE_DELETE = 'DELETE'

A constant which can be used with the access_type property of a DatabaseTableAccessEntrySummary. This constant has a value of “DELETE”

ACCESS_TYPE_INSERT = 'INSERT'

A constant which can be used with the access_type property of a DatabaseTableAccessEntrySummary. This constant has a value of “INSERT”

ACCESS_TYPE_OWNER = 'OWNER'

A constant which can be used with the access_type property of a DatabaseTableAccessEntrySummary. This constant has a value of “OWNER”

ACCESS_TYPE_SELECT = 'SELECT'

A constant which can be used with the access_type property of a DatabaseTableAccessEntrySummary. This constant has a value of “SELECT”

ACCESS_TYPE_UPDATE = 'UPDATE'

A constant which can be used with the access_type property of a DatabaseTableAccessEntrySummary. 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 DatabaseTableAccessEntrySummary. This constant has a value of “CREATE_ANY_INDEX”

PRIVILEGE_DELETE = 'DELETE'

A constant which can be used with the privilege property of a DatabaseTableAccessEntrySummary. 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 DatabaseTableAccessEntrySummary. 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 DatabaseTableAccessEntrySummary. 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 DatabaseTableAccessEntrySummary. This constant has a value of “GRANT_OPTION”

PRIVILEGE_INDEX = 'INDEX'

A constant which can be used with the privilege property of a DatabaseTableAccessEntrySummary. This constant has a value of “INDEX”

PRIVILEGE_INSERT = 'INSERT'

A constant which can be used with the privilege property of a DatabaseTableAccessEntrySummary. 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 DatabaseTableAccessEntrySummary. This constant has a value of “INSERT_ANY_TABLE”

PRIVILEGE_OWNER = 'OWNER'

A constant which can be used with the privilege property of a DatabaseTableAccessEntrySummary. This constant has a value of “OWNER”

PRIVILEGE_READ = 'READ'

A constant which can be used with the privilege property of a DatabaseTableAccessEntrySummary. 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 DatabaseTableAccessEntrySummary. This constant has a value of “READ_ANY_TABLE”

PRIVILEGE_SELECT = 'SELECT'

A constant which can be used with the privilege property of a DatabaseTableAccessEntrySummary. 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 DatabaseTableAccessEntrySummary. This constant has a value of “SELECT_ANY_TABLE”

PRIVILEGE_UPDATE = 'UPDATE'

A constant which can be used with the privilege property of a DatabaseTableAccessEntrySummary. 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 DatabaseTableAccessEntrySummary. This constant has a value of “UPDATE_ANY_TABLE”

__init__(**kwargs)

Initializes a new DatabaseTableAccessEntrySummary 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 DatabaseTableAccessEntrySummary.

• grantee (str) – The value to assign to the grantee property of this DatabaseTableAccessEntrySummary.

• grant_from_role (str) – The value to assign to the grant_from_role property of this DatabaseTableAccessEntrySummary.

• access_type (str) – The value to assign to the access_type property of this DatabaseTableAccessEntrySummary. 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 DatabaseTableAccessEntrySummary.

• table_name (str) – The value to assign to the table_name property of this DatabaseTableAccessEntrySummary.

• privilege_type (str) – The value to assign to the privilege_type property of this DatabaseTableAccessEntrySummary.

• target_id (str) – The value to assign to the target_id property of this DatabaseTableAccessEntrySummary.

• access_through_object (str) – The value to assign to the access_through_object property of this DatabaseTableAccessEntrySummary.

• privilege (str) – The value to assign to the privilege property of this DatabaseTableAccessEntrySummary. 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 DatabaseTableAccessEntrySummary. 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’.

• column_name (str) – The value to assign to the column_name property of this DatabaseTableAccessEntrySummary.

• grantor (str) – The value to assign to the grantor property of this DatabaseTableAccessEntrySummary.

• are_all_tables_accessible (bool) – The value to assign to the are_all_tables_accessible property of this DatabaseTableAccessEntrySummary.

• is_access_constrained_by_view (bool) – The value to assign to the is_access_constrained_by_view property of this DatabaseTableAccessEntrySummary.

• is_access_constrained_by_label_security (bool) – The value to assign to the is_access_constrained_by_label_security property of this DatabaseTableAccessEntrySummary.

• is_access_constrained_by_database_vault (bool) – The value to assign to the is_access_constrained_by_database_vault property of this DatabaseTableAccessEntrySummary.

• is_access_constrained_by_virtual_private_database (bool) – The value to assign to the is_access_constrained_by_virtual_private_database property of this DatabaseTableAccessEntrySummary.

• is_access_constrained_by_redaction (bool) – The value to assign to the is_access_constrained_by_redaction property of this DatabaseTableAccessEntrySummary.

• is_access_constrained_by_real_application_security (bool) – The value to assign to the is_access_constrained_by_real_application_security property of this DatabaseTableAccessEntrySummary.

• is_access_constrained_by_sql_firewall (bool) – The value to assign to the is_access_constrained_by_sql_firewall property of this DatabaseTableAccessEntrySummary.

• is_sensitive (bool) – The value to assign to the is_sensitive property of this DatabaseTableAccessEntrySummary.

property access_through_object

Gets the access_through_object of this DatabaseTableAccessEntrySummary. 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 DatabaseTableAccessEntrySummary.

Return type

str

property access_type

Gets the access_type of this DatabaseTableAccessEntrySummary. 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 DatabaseTableAccessEntrySummary.

Return type

str

property are_all_tables_accessible

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

Returns

The are_all_tables_accessible of this DatabaseTableAccessEntrySummary.

Return type

bool

property column_name

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

Returns

The column_name of this DatabaseTableAccessEntrySummary.

Return type

str

property grant_from_role

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

Return type

str

property grantee

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

Returns

The grantee of this DatabaseTableAccessEntrySummary.

Return type

str

property grantor

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

Returns

The grantor of this DatabaseTableAccessEntrySummary.

Return type

str

property is_access_constrained_by_database_vault

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

Returns

The is_access_constrained_by_database_vault of this DatabaseTableAccessEntrySummary.

Return type

bool

property is_access_constrained_by_label_security

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

Returns

The is_access_constrained_by_label_security of this DatabaseTableAccessEntrySummary.

Return type

bool

property is_access_constrained_by_real_application_security

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

Returns

The is_access_constrained_by_real_application_security of this DatabaseTableAccessEntrySummary.

Return type

bool

property is_access_constrained_by_redaction

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

Returns

The is_access_constrained_by_redaction of this DatabaseTableAccessEntrySummary.

Return type

bool

property is_access_constrained_by_sql_firewall

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

Returns

The is_access_constrained_by_sql_firewall of this DatabaseTableAccessEntrySummary.

Return type

bool

property is_access_constrained_by_view

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

Returns

The is_access_constrained_by_view of this DatabaseTableAccessEntrySummary.

Return type

bool

property is_access_constrained_by_virtual_private_database

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

Returns

The is_access_constrained_by_virtual_private_database of this DatabaseTableAccessEntrySummary.

Return type

bool

property is_sensitive

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

Returns

The is_sensitive of this DatabaseTableAccessEntrySummary.

Return type

bool

property key

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

Returns

The key of this DatabaseTableAccessEntrySummary.

Return type

str

property privilege

Gets the privilege of this DatabaseTableAccessEntrySummary. 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 DatabaseTableAccessEntrySummary.

Return type

str

property privilege_grantable

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

Return type

str

property privilege_type

Gets the privilege_type of this DatabaseTableAccessEntrySummary. 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 DatabaseTableAccessEntrySummary.

Return type

str

property table_name

Gets the table_name of this DatabaseTableAccessEntrySummary. Name of the database table the user has access to.

Returns

The table_name of this DatabaseTableAccessEntrySummary.

Return type

str

property table_schema

Gets the table_schema of this DatabaseTableAccessEntrySummary. Name of the schema the table belongs to.

Returns

The table_schema of this DatabaseTableAccessEntrySummary.

Return type

str

property target_id

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

Returns

The target_id of this DatabaseTableAccessEntrySummary.

Return type

str