DBA Data[Home] [Help] [Dependency Information]


VIEW: SYS.CDB_TSDP_POLICY_PROTECTION

Object Details
Object Name: CDB_TSDP_POLICY_PROTECTION
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Lists the proptection enabled through TSDP in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
SCHEMA_NAME VARCHAR2 (30) Yes The schema containing the sensitive data
TABLE_NAME VARCHAR2 (30) Yes The table containing the sensitive data
COLUMN_NAME VARCHAR2 (30) Yes The sensitive column
TSDP_POLICY VARCHAR2 (128)
The TSDP policy based on which protection was enabled
SECURITY_FEATURE VARCHAR2 (12)
The security feature enabled on the sensitive data
SECURITY_FEATURE_POLICY VARCHAR2 (128) Yes Name of the underlying security feature policy
SUBPOLICY# NUMBER
Yes The subpolicy of the TSDP policy based on which protection has been enabled
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SCHEMA_NAME
,      TABLE_NAME
,      COLUMN_NAME
,      TSDP_POLICY
,      SECURITY_FEATURE
,      SECURITY_FEATURE_POLICY
,      SUBPOLICY#
,      CON_ID
FROM SYS.CDB_TSDP_POLICY_PROTECTION;

Dependencies

[top of page]

SYS.CDB_TSDP_POLICY_PROTECTION does not reference any database object

SYS.CDB_TSDP_POLICY_PROTECTION is referenced by following:

SchemaPUBLIC
SynonymCDB_TSDP_POLICY_PROTECTION