Tuesday, July 26, 2005

granting trace privilege to a user

GRANTING TRACE PRIVILEGE TO USER


1. connect to oracle as sys as sysdba
2. Run the plustrce.sql (file will in the path ORACLE_HOME\sqlplus\admin\plustrce.sql.)
For example: E:\oracle\ora92\sqlplus\admin\plustrce.sql
Please see the below screen for reference.




4. Grant the plustrace privilege to the user as below

0 Comments:

Post a Comment

<< Home