PLUSTRACE included in SELECT_CATALOG_ROLE

Autotrace 功能已经包括在 SELECT_CATALOG_ROLE 当中，也就是说不用再另外 GRANT PLUSTRACE to user.

SELECT * FROM DBA_TAB_PRIVS WHERE GRANTEE = 'SELECT_CATALOG_ROLE' AND TABLE_NAME IN ('V_$SESSTAT', 'V_$STATNAME', 'V_$MYSTAT');

 

plustrce.sql

set echo on

drop role plustrace;
create role plustrace;

grant select on v_$sesstat to plustrace;
grant select on v_$statname to plustrace;
grant select on v_$mystat to plustrace;
grant plustrace to dba with admin option;

set echo off