jueves, 28 de noviembre de 2013

How to enable Oracle Label Security

This example is for Oracle Database 12c already installed, but you can execute on previous database version (from 9i and above)

Open a DBCA console and select on Configure Database Options:



















Select your database and click on next



















In that page you can install OLS selecting it and clicking on next and later on finish (if you can't click on it is  like in the photo is because you have installed it when you installed database)




















Let finish the installation and open again DBCA and this time click on "Manage connection database":



















Configure Connection Database:



















Select your database:



















Select your Conecction Database:



















Enable "Configure Label Security"



















Next and Finish and you got it installed.


Now, you must unlock LBACSYS user and grant "select any dictionary" on It, so connect to sqlplus as SYS user and execute (connect to your database, NOT to connection database):

SQL> ALTER USER LBACSYS identified by LBCASYS;
SQL> ALTER USER LBACSYS account UNLOCK;
SQL> GRANT SELECT ANY DICTIONARY to LBACSYS CONTAINER=all;

and run catols.sql:
SQL>@$ORACLE_HOME/rdbms/admin/catols.sql


Verify OLS installation (LBACSYS must have objects and all must be valid):



















Now you have OLS installed and enabled. Now you can create OLS policy.



No hay comentarios:

Publicar un comentario