CREATE USER "OPS$AAAAXDVP"
IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE AXTAB
TEMPORARY TABLESPACE AXTMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
GRANT RESOURCE TO "OPS$BBBAXDVP";
GRANT CONNECT TO "OPS$BBBAXDVP";
ALTER USER "OPS$AVONAPAXDVP" DEFAULT ROLE ALL;
BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
PRIVILEGE => SYS.DBMS_RULE_ADM.ALTER_ANY_RULE_SET,
GRANTEE => 'OPS$BBBAXDVP',
GRANT_OPTION => TRUE);
END;
/
GRANT EXECUTE ANY LIBRARY TO OPS$AVONAPAXDVP;
如果照此权限直接执行，会报如下错误：
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
*
ERROR at line 2:
ORA-00911: invalid character
ORA-24000: invalid value OPS$BBBAXDVP, USER/ROLE should be of the form
[SCHEMA.]NAME
ORA-00911: invalid character
ORA-06512: at "SYS.DBMS_RULE_ADM", line 289
ORA-06512: at line 2
