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

VIEW: SYS.CDB_SENSITIVE_DATA

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

All sensitive data in the database identified using TSDP in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
SENSITIVE# NUMBER
Yes Unique ID for the sensitive data
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 column identified as sensitive
SENSITIVE_TYPE VARCHAR2 (128)
The sensitive type of the data
SOURCE_NAME VARCHAR2 (128)
The source of identification of the sensitive data
USER_COMMENT VARCHAR2 (128)
User comment regarding the sensitive data
TS TIMESTAMP(6) WITH TIME ZONE (13)
The time when the data as identified as sensitive in the database
CON_ID NUMBER

container id
Query Text

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


SELECT SENSITIVE#
,      SCHEMA_NAME
,      TABLE_NAME
,      COLUMN_NAME
,      SENSITIVE_TYPE
,      SOURCE_NAME
,      USER_COMMENT
,      TS
,      CON_ID
FROM SYS.CDB_SENSITIVE_DATA;

Dependencies

[top of page]

SYS.CDB_SENSITIVE_DATA does not reference any database object

SYS.CDB_SENSITIVE_DATA is referenced by following:

SchemaPUBLIC
SynonymCDB_SENSITIVE_DATA