如果在pdb里enable了dv的话则会无法跨schema创建表

enable PDB vault1pdb88888的dv

06:21:58 SQL> connect c##dv_cloud_admin_backup/vault1@vault1pdb88888
Connected.
06:22:54 SQL> exec dbms_macadm.enable_dv;

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.01

06:22:09 SQL> select * from dba_dv_status;

NAME		     STATUS
-------------------- --------------
DV_CONFIGURE_STATUS  TRUE
DV_ENABLE_STATUS     TRUE
DV_APP_PROTECTION    ENABLED

用户u2在u1里面创建表的话，会报没有权限 ora-01031

06:22:23 SQL> show user;
USER is "U2"
06:25:06 SQL> create table u1.tt2(a varchar2(20));
create table u1.tt2(a varchar2(20))
*
ERROR at line 1:
ORA-01031: insufficient privileges


Elapsed: 00:00:00.01

将dv disabled

06:23:03 SQL> exec dbms_macadm.disable_dv;

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.00


06:23:18 SQL> select * from dba_dv_status;

NAME		     STATUS
-------------------- --------------
DV_CONFIGURE_STATUS  TRUE
DV_ENABLE_STATUS     FALSE
DV_APP_PROTECTION    ENABLED

Elapsed: 00:00:00.00

disable dv之后，则会可以跨schema创建表

06:25:19 SQL> create table u1.tt2(a varchar2(20));

Table created.

Elapsed: 00:00:00.02