Skip to Main Content
  • Questions
  • Data dictionary classifying column sensitivity


Question and Answer

Connor McDonald

Thanks for the question, Mitchell.

Asked: March 03, 2023 - 7:39 pm UTC

Last updated: March 14, 2023 - 1:12 am UTC


Viewed 100+ times

You Asked

My agency uses the column and table comments for describing the data being held by the column or table.

I have been asked to classify the data as to its sensitivity. Low, Medium, High, etc.

Is there a place in the Oracle data dictionary where I can add those types classifications?
I read about Oracle Label security, but I am not trying to limit access to the data through the database.

I can always create my own table, but I am hoping that maybe this has already been implemented somewhere and I am just missing it.

and Connor said...

In an upcoming release, we have a feature called "Annotations" that will handle this for you, but until then, I think you're stuck with using COMMENTS.

If the table/column comments cannot be augmented, you could create a schema just for this purpose and create a view on each table.

Then add you comments to the view / view columns, thus keeping it separated from the true table / column comments.

SQL> create view demo.emp as select * from scott.emp;

View created.

SQL> comment on table demo.emp is 'Place for classifying scott.emp';

Comment created.

SQL> comment on column demo.emp.empno is 'EMPNO is classified public';

Comment created.


  (1 rating)


Thank you.

Mitchell Ryan, March 09, 2023 - 7:08 pm UTC

Thank you.
Connor McDonald
March 14, 2023 - 1:12 am UTC

glad to help

More to Explore


New to good database design? Check out Chris Saxon's full fundamentals class.