vault在主库配置了领域,在从库不会生效的
主库查询:
SQL> set linesize 1000;
SQL>
SQL> select * from v$option where parameter like '%Vault%';
PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Oracle Database Vault TRUE
connect / as sysdba
SQL> select * from hxl100.tb_100;
select * from hxl100.tb_100
*
ERROR at line 1:
ORA-01031: insufficient privileges
从库查询
connect / as sysdba
SQL> select * from hxl100.tb_100;
ID NAME
---------- --------------------------------
1 name1
2 name2
SQL> set linesize 1000;
SQL> select * from v$option where parameter like '%Vault%';
PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Oracle Database Vault FALSE