Re: HELP!! can NOT use package "dbms_system.set_sql_trace_in_session
From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1996/11/03
Message-ID: <55h5np$b8t_at_newton.pacific.net.sg>#1/1
Date: 1996/11/03
Message-ID: <55h5np$b8t_at_newton.pacific.net.sg>#1/1
Log in as user SYS and find out whether dbms_system package exist. If so, then create an public synonym for that package and give grant execute any procedure to all the users in the system.
If you can't find the package, go to $ORACLE_HOME/rdbms/admin directory and grep for 'dbms_system'
grep -i 'dbms_system' *.sql
There should be a sql file which will create this package. Execute that SQL as user sys and create an public synonym and give the appropriate grants.
Regards
N.Prabhakar
email : prabhs_at_pacific.net.sg
Received on Sun Nov 03 1996 - 00:00:00 CET