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