PLUSTRACE included in SELECT_CATALOG_ROLE

Autotrace 功能已经包括在 SELECT_CATALOG_ROLE 当中，

也就是说不用再另外 GRANT PLUSTRACE to user.

www.2cto.com

Sql代码

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

plustrce.sql

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