| PLUSTRACE Role [message #65071] |
Wed, 14 April 2004 22:22  |
Avi
Messages: 23
Registered: January 2002
|
Junior Member |
|
|
Hi Guys,
I just created pln_table in my local schema. and then tried doing set sqltrace on and it gave me the following error.
Can any body point me to what's that. and what is a plustrace role involve.
Another question round this is that how do we see what privileges are enabled with a particular role.
*****ERROR ON SET AUTOTRACE ON***************
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
|
|
|
|
| Re: PLUSTRACE Role [message #65074 is a reply to message #65071] |
Thu, 15 April 2004 05:29  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
You need to do the following:
SQL> connect SYS AS SYSDBA
SQL> @?/sqlplus/admin/plustrce.sql
SQL> grant plustrace to public;
Best regards.
Frank
|
|
|
|
| Re: PLUSTRACE Role [message #65087 is a reply to message #65074] |
Sun, 25 April 2004 02:43 |
Binu
Messages: 4
Registered: August 2002
|
Junior Member |
|
|
If you are using Oracle 9i, executing @?/sqlplus/admin/plustrce.sql won't give proper access to autotrace.
You also need to give select access on v_$mystat view to the Plustrace role.
Best regards,
Binu
|
|
|
|
| Re: PLUSTRACE Role [message #65478 is a reply to message #65074] |
Fri, 01 October 2004 01:54 |
Brad
Messages: 12
Registered: April 1999
|
Junior Member |
|
|
PLUSTRACE grants by default SELECT on following tables:
V_$MYSTAT
V_$SESSTAT
V_$STATNAME
ORACLE 9 requires one additional SELECT grant on table:
V_$SESSION
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
