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

VIEW: SYS.DBA_TSDP_POLICY_PROTECTION

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

Lists the proptection enabled through TSDP

[View Source]

Columns
Name Datatype Length Mandatory Comments
SCHEMA_NAME VARCHAR2 (128) Yes The schema containing the sensitive data
TABLE_NAME VARCHAR2 (128) Yes The table containing the sensitive data
COLUMN_NAME VARCHAR2 (128) 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
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#
FROM SYS.DBA_TSDP_POLICY_PROTECTION;

Dependencies

[top of page]

SYS.DBA_TSDP_POLICY_PROTECTION references the following:

SchemaSYS
TableCOL$
TableOBJ$
TableTSDP_FEATURE_POLICY$
TableTSDP_POLICY$
TableTSDP_PROTECTION$
TableTSDP_SENSITIVE_DATA$
TableTSDP_SUBPOL$
TableUSER$
SYS.DBA_TSDP_POLICY_PROTECTION is referenced by following:

SchemaPUBLIC
SynonymDBA_TSDP_POLICY_PROTECTION