Home » RDBMS Server » Server Administration » Permission issues while using sql trace (merged)
Permission issues while using sql trace (merged) [message #416890] Wed, 05 August 2009 01:03 Go to next message
ashish1986
Messages: 12
Registered: July 2008
Junior Member
Dear All,
Regards of the Day

I am cureently managing a 10.2.0.4 Oracle DB Server on Linux.

We have a dedicated performance team which does performance testing and enhancement.

For this purpose they need traces quite often.

I don't wish to share either the unix login or the sysdba login with them.

Is there any other way possible in which they can generate sql trace of the applcation.

There are other logins on the unix server as well.

Can those be used.
Re: Permission issues while using sql trace [message #416894 is a reply to message #416890] Wed, 05 August 2009 01:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Share udump directory with these Unix accounts and set "_trace_files_public" parameter to TRUE.

Regards
Michel
Re: Issues while generating trace [message #416899 is a reply to message #416890] Wed, 05 August 2009 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DO NOT multipost/crosspost your question.

Regards
Michel
Re: Permission issues while using sql trace [message #416903 is a reply to message #416894] Wed, 05 August 2009 01:35 Go to previous messageGo to next message
ashish1986
Messages: 12
Registered: July 2008
Junior Member
Dear Michael,

thank you fpr your reply.
I have shared the udump directory and also set theparamter to true.

However when i use some another unix login on the same server
with a db user without dba privileges .

I get the following error:
SQL> exec dbms_system.set_sql_trace_on_session('543','12393',true);
BEGIN dbms_system.set_sql_trace_on_session('543','12393',true); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_ON_SESSION' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

I have given

SQL> grant select on v_$session to dbuser;
Grant succeeded.
SQL> grant select on v_$process to dbuser;
Grant succeeded.
SQL> grant select on v_$instance to dbuser;
Grant succeeded.
SQL> grant all on dbms_system to dbuser;
Grant succeeded.

But it still does not work..

Please suggest.

I wpould like to restate :
My objective was to take an sql trace from a DB User without having dba privileges and from a unxi login other than oracle.

Thanks and Regards
Ashish
Re: Permission issues while using sql trace [message #416905 is a reply to message #416903] Wed, 05 August 2009 01:41 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As you are in 10g, use DBMS_MONITOR and grant the user the privilege to execute it.

Regards
Michel
Previous Topic: Get a list of schemas which are able to update into objects under another user
Next Topic: data dictionary views
Goto Forum:
  


Current Time: Mon Dec 05 19:01:29 CST 2016

Total time taken to generate the page: 0.11799 seconds