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
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;
SQL> comment on table demo.emp is 'Place for classifying scott.emp';
SQL> comment on column demo.emp.empno is 'EMPNO is classified public';