1、
通过 dva 来创建用户。
SQL> connect dva/PreDva13588
Connected.
SQL> create user acct identified by acct;
User created.
2、 通过 SYS 来给用户进行授权。
[oracle@PJKMISDB OPatch]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 23 11:04:07 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL> grant create session to test5;
Grant succeeded.
SQL> grant resource to test5;
Grant succeeded.
3、配置 database vault
在浏览器中输入 https://192.168.126.41:1158/dva
保护对象为acct用户下的所有内容,权限授予acct自身。
4、进行测试
创建一个用户 test ,授予 create session 权限,并将 acct 下的一张测试表 emp 的查询权限赋予它
SQL> connect test/test@//localhost/pdb1
Connected.
SQL> select * from acct.emp;
ID
----------
100
400
500
200
300
通过 SYS 用户进行测试,可以看到 SYS 用户并没有权限访问此表
SQL> connect / as sysdba
Connected.
SQL> select * from acct.emp;
select * from test.emp
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> connect dva/PreDva13588
Connected.
SQL> create user acct identified by acct;
User created.
2、 通过 SYS 来给用户进行授权。
[oracle@PJKMISDB OPatch]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 23 11:04:07 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL> grant create session to test5;
Grant succeeded.
SQL> grant resource to test5;
Grant succeeded.
在浏览器中输入 https://192.168.126.41:1158/dva
保护对象为acct用户下的所有内容,权限授予acct自身。
4、进行测试
创建一个用户 test ,授予 create session 权限,并将 acct 下的一张测试表 emp 的查询权限赋予它
SQL> connect test/test@//localhost/pdb1
Connected.
SQL> select * from acct.emp;
ID
----------
100
400
500
200
300
SQL> connect / as sysdba
Connected.
SQL> select * from acct.emp;
select * from test.emp
*
ERROR at line 1:
ORA-01031: insufficient privileges
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26506993/viewspace-1844233/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26506993/viewspace-1844233/