CODEWITHSUNDEEP
oracle-databaseoracle11goracle10g
Chanky Mallick
Chanky Mallick

Reputation: 587

Oracle database have any feature to add Sensitive Data Indicator to a Column?

Does Oracle supports storing columns Sensitive Indicator similar to following SQL Server ?

CREATE TABLE STUDENT (SNAME VARCHAR(1000))

ADD SENSITIVITY CLASSIFICATION TO
dbo.STUDENT.SNAME
WITH ( LABEL='Highly Confidential', INFORMATION_TYPE='Financial', RANK=CRITICAL )

Then we can fetch this Information with the following query.

SELECT *FROM sys.sensitivity_classifications

Is Oracle Database have any feature similar to this?

SQLServer Documentation : SQLServer_Documention_For_Sensitive_Data_Indicator

Upvotes: 1

Views: 183

Answers (1)

Thorsten Kettner
Thorsten Kettner

Reputation: 94884

As far as I know, Oracle doesn't have this feature. Oracle introduced transparent sensitive data protection in Oracle 12c. Please see Alex Poole's comment and the link he posted on that.

If it's only about adding this information to a column in order to find it in the database, you can always add comments on columns to the data dictionary that you can use for this purpose:

COMMENT ON COLUMN mytable.mycolumn IS 'SENSITIVITY CLASSIFICATION="Highly Confidential", INFORMATION_TYPE="Financial", RANK="CRITICAL"';

You can find these columns as follows for example:

SELECT * FROM dba_col_comments WHERE comments LIKE '%SENSITIVITY CLASSIFICATION%';

Upvotes: 1

Related Questions