OLS是数据库控制数据隐私的一个组件,原理是在为每条数据加一个伪劣(标签列),标签是有权限等级的,通过这个来控制用户访问表的数据权限。
oracle 10g下安装的大致步骤:
1. 在开始菜单中点击 /Oracle - OraDb10g_home1/Oracle Installation Products/Universal Installer开始安装;
2. 出现窗口选择安装类型,选择定制;
3. 然后下一步,下一步到可用产品组件时,在oracle label security 10.2.0.1.0 上打钩后安装;
4. 在开始菜单中点击/Oracle - OraDb10g_home1/配置和移植工具/Database Configuration Assistant;
5. 出现数据库组件窗口时,选择oracle label security后点下一步;
6. 安装完成后重启数据库;
7. 打开cmd ,以 sqlplus lbacsys/lbacsys登录,如果报账号被锁则执行alter user lbacsys account unlock;
Once installed in the database will be called "LBACSYS" the user, the password is "LBACSYS" the user will manage our security policy![](http://www.codeweblog.com/upload/o/r/oracle-label-security-oracle-label-security_1.jpg)
![](http://www.codeweblog.com/upload/o/r/oracle-label-security-oracle-label-security_2.jpg)
* The name and path where oracle installation path must be
![](http://www.codeweblog.com/upload/o/r/oracle-label-security-oracle-label-security_3_thumb.jpg)
* In Select Oracle Label Security component here
![](http://www.codeweblog.com/upload/o/r/oracle-label-security-oracle-label-security_4_thumb.jpg)
![](http://www.codeweblog.com/upload/o/r/oracle-label-security-oracle-label-security_5_thumb.jpg)