Home » RDBMS Server » Server Administration » Sysdba logging as another user
Sysdba logging as another user [message #242786] Tue, 05 June 2007 02:04 Go to next message
ram_ocp
Messages: 49
Registered: December 2005
Location: Karnataka
Member
Hi,

I want to know if there is any way in Oracle 9i or 10g where the Sysdba can login as a normal database user and execute some tasks.For eg if i am a sysdba and i want to login as a database user(say Ram) and execute some function but i dont know the password

I know one where i can change the user password,execute the package and again put the old password back from password column in dba_users,but this is not the reight way.

Please suggest

Ram
Re: Sysdba logging as another user [message #242795 is a reply to message #242786] Tue, 05 June 2007 02:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no other way to do it.
There is no "su" procedure in Oracle.

Regards
Michel
Re: Sysdba logging as another user [message #242877 is a reply to message #242786] Tue, 05 June 2007 06:50 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
if RAM is assigned as Sysdba ,RAM has privilege to anything.i am wondering why you require to login as RAM/Password ?
Re: Sysdba logging as another user [message #242880 is a reply to message #242877] Tue, 05 June 2007 07:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is a quite good question.
Maybe to not do something that must not be done with SYSDBA privilege?

Regards
Michel
Re: Sysdba logging as another user [message #242925 is a reply to message #242786] Tue, 05 June 2007 09:18 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Ram, another option is to connect as 'OPS$<OSUSERNAME>'
Previous Topic: DBMS job hanging
Next Topic: Generating STATISTICS
Goto Forum:
  


Current Time: Sun Dec 04 00:33:57 CST 2016

Total time taken to generate the page: 0.05547 seconds