DatabaseViewAccessEntrySummary

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

Bases: object

Summary of DatabaseViewAccess Object.

Attributes:

ACCESS_TYPE_DELETE

A constant which can be used with the access_type property of a DatabaseViewAccessEntrySummary.

ACCESS_TYPE_INSERT

A constant which can be used with the access_type property of a DatabaseViewAccessEntrySummary.

ACCESS_TYPE_OWNER

A constant which can be used with the access_type property of a DatabaseViewAccessEntrySummary.

ACCESS_TYPE_SELECT

A constant which can be used with the access_type property of a DatabaseViewAccessEntrySummary.

ACCESS_TYPE_UPDATE

A constant which can be used with the access_type property of a DatabaseViewAccessEntrySummary.

PRIVILEGE_CREATE_ANY_INDEX

A constant which can be used with the privilege property of a DatabaseViewAccessEntrySummary.

PRIVILEGE_DELETE

A constant which can be used with the privilege property of a DatabaseViewAccessEntrySummary.

PRIVILEGE_DELETE_ANY_TABLE

A constant which can be used with the privilege property of a DatabaseViewAccessEntrySummary.

PRIVILEGE_GRANTABLE_ADMIN_OPTION

A constant which can be used with the privilege_grantable property of a DatabaseViewAccessEntrySummary.

PRIVILEGE_GRANTABLE_GRANT_OPTION

A constant which can be used with the privilege_grantable property of a DatabaseViewAccessEntrySummary.

PRIVILEGE_INDEX

A constant which can be used with the privilege property of a DatabaseViewAccessEntrySummary.

PRIVILEGE_INSERT

A constant which can be used with the privilege property of a DatabaseViewAccessEntrySummary.

PRIVILEGE_INSERT_ANY_TABLE

A constant which can be used with the privilege property of a DatabaseViewAccessEntrySummary.

PRIVILEGE_OWNER

A constant which can be used with the privilege property of a DatabaseViewAccessEntrySummary.

PRIVILEGE_READ

A constant which can be used with the privilege property of a DatabaseViewAccessEntrySummary.

PRIVILEGE_READ_ANY_TABLE

A constant which can be used with the privilege property of a DatabaseViewAccessEntrySummary.

PRIVILEGE_SELECT

A constant which can be used with the privilege property of a DatabaseViewAccessEntrySummary.

PRIVILEGE_SELECT_ANY_TABLE

A constant which can be used with the privilege property of a DatabaseViewAccessEntrySummary.

PRIVILEGE_UPDATE

A constant which can be used with the privilege property of a DatabaseViewAccessEntrySummary.

PRIVILEGE_UPDATE_ANY_TABLE

A constant which can be used with the privilege property of a DatabaseViewAccessEntrySummary.

access_type

Gets the access_type of this DatabaseViewAccessEntrySummary.

column_name

Gets the column_name of this DatabaseViewAccessEntrySummary.

grant_from_role

Gets the grant_from_role of this DatabaseViewAccessEntrySummary.

grantee

[Required] Gets the grantee of this DatabaseViewAccessEntrySummary.

grantor

Gets the grantor of this DatabaseViewAccessEntrySummary.

is_access_constrained_by_database_vault

Gets the is_access_constrained_by_database_vault of this DatabaseViewAccessEntrySummary.

is_access_constrained_by_real_application_security

Gets the is_access_constrained_by_real_application_security of this DatabaseViewAccessEntrySummary.

is_access_constrained_by_redaction

Gets the is_access_constrained_by_redaction of this DatabaseViewAccessEntrySummary.

is_access_constrained_by_sql_firewall

Gets the is_access_constrained_by_sql_firewall of this DatabaseViewAccessEntrySummary.

is_access_constrained_by_virtual_private_database

Gets the is_access_constrained_by_virtual_private_database of this DatabaseViewAccessEntrySummary.

key

[Required] Gets the key of this DatabaseViewAccessEntrySummary.

privilege

Gets the privilege of this DatabaseViewAccessEntrySummary.

privilege_grantable

Gets the privilege_grantable of this DatabaseViewAccessEntrySummary.

privilege_type

Gets the privilege_type of this DatabaseViewAccessEntrySummary.

table_name

Gets the table_name of this DatabaseViewAccessEntrySummary.

table_schema

Gets the table_schema of this DatabaseViewAccessEntrySummary.

target_id

Gets the target_id of this DatabaseViewAccessEntrySummary.

view_name

Gets the view_name of this DatabaseViewAccessEntrySummary.

view_schema

Gets the view_schema of this DatabaseViewAccessEntrySummary.

view_text

Gets the view_text of this DatabaseViewAccessEntrySummary.

Methods:

__init__(**kwargs)

Initializes a new DatabaseViewAccessEntrySummary object with values from keyword arguments.

ACCESS_TYPE_DELETE = 'DELETE'

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

ACCESS_TYPE_INSERT = 'INSERT'

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

ACCESS_TYPE_OWNER = 'OWNER'

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

ACCESS_TYPE_SELECT = 'SELECT'

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

ACCESS_TYPE_UPDATE = 'UPDATE'

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

PRIVILEGE_DELETE = 'DELETE'

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

PRIVILEGE_INDEX = 'INDEX'

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

PRIVILEGE_INSERT = 'INSERT'

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

PRIVILEGE_OWNER = 'OWNER'

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

PRIVILEGE_READ = 'READ'

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

PRIVILEGE_SELECT = 'SELECT'

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

PRIVILEGE_UPDATE = 'UPDATE'

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

__init__(**kwargs)

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

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

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

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

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

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

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

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

  • table_schema (str) – The value to assign to the table_schema property of this DatabaseViewAccessEntrySummary.

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

  • view_schema (str) – The value to assign to the view_schema property of this DatabaseViewAccessEntrySummary.

  • view_name (str) – The value to assign to the view_name property of this DatabaseViewAccessEntrySummary.

  • view_text (str) – The value to assign to the view_text property of this DatabaseViewAccessEntrySummary.

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

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

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

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

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

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

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

property access_type

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

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 DatabaseViewAccessEntrySummary.

Return type

str

property column_name

Gets the column_name of this DatabaseViewAccessEntrySummary. The name of column when there are column level privileges on a table or view.

Returns

The column_name of this DatabaseViewAccessEntrySummary.

Return type

str

property grant_from_role

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

Return type

str

property grantee

[Required] Gets the grantee of this DatabaseViewAccessEntrySummary. Grantee is the user who can access the view.

Returns

The grantee of this DatabaseViewAccessEntrySummary.

Return type

str

property grantor

Gets the grantor of this DatabaseViewAccessEntrySummary. The user who granted the privilege.

Returns

The grantor of this DatabaseViewAccessEntrySummary.

Return type

str

property is_access_constrained_by_database_vault

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

Returns

The is_access_constrained_by_database_vault of this DatabaseViewAccessEntrySummary.

Return type

bool

property is_access_constrained_by_real_application_security

Gets the is_access_constrained_by_real_application_security of this DatabaseViewAccessEntrySummary. Indicates whether the view access is constrained via Real Application Security.

Returns

The is_access_constrained_by_real_application_security of this DatabaseViewAccessEntrySummary.

Return type

bool

property is_access_constrained_by_redaction

Gets the is_access_constrained_by_redaction of this DatabaseViewAccessEntrySummary. Indicates whether the view access is constrained via Oracle Data Redaction.

Returns

The is_access_constrained_by_redaction of this DatabaseViewAccessEntrySummary.

Return type

bool

property is_access_constrained_by_sql_firewall

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

Returns

The is_access_constrained_by_sql_firewall of this DatabaseViewAccessEntrySummary.

Return type

bool

property is_access_constrained_by_virtual_private_database

Gets the is_access_constrained_by_virtual_private_database of this DatabaseViewAccessEntrySummary. Indicates whether the view access is constrained via Virtual Private Database.

Returns

The is_access_constrained_by_virtual_private_database of this DatabaseViewAccessEntrySummary.

Return type

bool

property key

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

Returns

The key of this DatabaseViewAccessEntrySummary.

Return type

str

property privilege

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

Return type

str

property privilege_grantable

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

Return type

str

property privilege_type

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

Return type

str

property table_name

Gets the table_name of this DatabaseViewAccessEntrySummary. The name of the table.

Returns

The table_name of this DatabaseViewAccessEntrySummary.

Return type

str

property table_schema

Gets the table_schema of this DatabaseViewAccessEntrySummary. The name of the schema

Returns

The table_schema of this DatabaseViewAccessEntrySummary.

Return type

str

property target_id

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

Returns

The target_id of this DatabaseViewAccessEntrySummary.

Return type

str

property view_name

Gets the view_name of this DatabaseViewAccessEntrySummary. The name of the view.

Returns

The view_name of this DatabaseViewAccessEntrySummary.

Return type

str

property view_schema

Gets the view_schema of this DatabaseViewAccessEntrySummary. The name of the schema.

Returns

The view_schema of this DatabaseViewAccessEntrySummary.

Return type

str

property view_text

Gets the view_text of this DatabaseViewAccessEntrySummary. The definition of the view.

Returns

The view_text of this DatabaseViewAccessEntrySummary.

Return type

str