@$ORACLE_HOME/rdbms/admin/utlxplan.sql
@$ORACLE_HOME/sqlplus/admin/plustrce.sql
grant plustrace to AAAA;
alter user ismp default role all;
select privilege from dba_sys_privs where grantee='AAAA'
union
select privilege from dba_sys_privs where grantee in (select granted_role from dba_role_privs where grantee='AAAA' );
@$ORACLE_HOME/sqlplus/admin/plustrce.sql
grant plustrace to AAAA;
alter user ismp default role all;
select privilege from dba_sys_privs where grantee='AAAA'
union
select privilege from dba_sys_privs where grantee in (select granted_role from dba_role_privs where grantee='AAAA' );
select * from dba_role_privs where grantee='AAAA';
SQL> conn AAAA/junshi
Connected.
SQL> set autotrace on
SQL>
参考:
SET AUTOTRACE fails with SP2-0618 and SP2-0611 (文档 ID 1159115.1)