Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace DatabaseTableAccessEntry

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.

Properties

Optional accessThroughObject

accessThroughObject: undefined | 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.

Optional accessType

accessType: model.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.

Optional areAllTablesAccessible

areAllTablesAccessible: undefined | false | true

Indicates whether the user has access to all the tables in the schema.

Optional columnName

columnName: undefined | string

If there are column level privileges on a table or view.

Optional grantFromRole

grantFromRole: undefined | 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.

Optional grantee

grantee: undefined | string

Grantee is the user who can access the table

Optional grantor

grantor: undefined | string

The one who granted this privilege.

Optional isAccessConstrainedByDatabaseVault

isAccessConstrainedByDatabaseVault: undefined | false | true

Indicates whether the table access is constrained via Oracle Database Vault.

Optional isAccessConstrainedByLabelSecurity

isAccessConstrainedByLabelSecurity: undefined | false | true

Indicates whether the table access is constrained via Oracle Label Security.

Optional isAccessConstrainedByRealApplicationSecurity

isAccessConstrainedByRealApplicationSecurity: undefined | false | true

Indicates whether the table access is constrained via Real Application Security.

Optional isAccessConstrainedByRedaction

isAccessConstrainedByRedaction: undefined | false | true

Indicates whether the table access is constrained via Oracle Data Redaction.

Optional isAccessConstrainedBySqlFirewall

isAccessConstrainedBySqlFirewall: undefined | false | true

Indicates whether the table access is constrained via Oracle Database SQL Firewall.

Optional isAccessConstrainedByView

isAccessConstrainedByView: undefined | false | true

Indicates whether the access is constrained on a table via a view.

Optional isAccessConstrainedByVirtualPrivateDatabase

isAccessConstrainedByVirtualPrivateDatabase: undefined | false | true

Indicates whether the table access is constrained via Virtual Private Database.

Optional isSensitive

isSensitive: undefined | false | true

Indicates whether the table is marked as sensitive.

key

key: string

The unique key that identifies the table access report. It is numeric and unique within a security policy report.

Optional privilege

privilege: model.PrivilegeName

Name of the privilege.

Optional privilegeGrantable

privilegeGrantable: model.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

Optional privilegeType

privilegeType: undefined | string

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

Optional tableName

tableName: undefined | string

The name of the database table the user has access to.

Optional tableSchema

tableSchema: undefined | string

The name of the schema the table belongs to.

Optional targetId

targetId: undefined | string

The OCID of the of the target database.

Functions

getDeserializedJsonObj

getJsonObj