Search notes:

Oracle Option: Label Security

Oracle Label Security is a framework for a fine-grained label based access control (LBAC). It allows to assign security labels to data or users in order to classify them.

Unlike Virtual Private Database, OLS provides an out-of-the-box security policy and a metadata repository for defining and storing labels

Install Oracle Label Security

Oracle Label Security can be installed with SQL*Plus:

$ cd $ORACLE_HOME/rdbms/admin
$ sqlplus / as sysdba
SQL> @catols

Some SQL Statements

select * from dba_users where username = 'LBACSYS';

select * from dba_views where view_name like 'DBA_SA%';

select * from DBA_REGISTRY where comp_name = 'Oracle Label Security';

Oracle Option: Label Security

Install Oracle Label Security

Some SQL Statements

See also