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