admin]$ sqlplus '/as sysdba'
SQL> @?/sqlplus/admin/plustrce.sql
SQL>
SQL> drop role plustrace;
drop role plustrace
*
ERROR at line 1:
ORA-01919: role 'PLUSTRACE' does not exist
SQL> create role plustrace;
Role created.
SQL>
SQL> grant select on v_$sesstat to plustrace;
Grant succeeded.
SQL> grant select on v_$statname to plustrace;
Grant succeeded.
SQL> grant select on v_$mystat to plustrace;
Grant succeeded.
SQL> grant plustrace to dba with admin option;
Grant succeeded.
SQL> grant plustrace to xxuser;
Grant succeeded.
GRANTEE TYP PRIVILEGE OR ROLE
------------------------------ --- --------------------------------------------------------------------------
XXUSER PLUSTRACE
Refer: AUTOTRACE Option in SQL*Plus (Doc ID 43214.1)
