OraFAQ Forum: Server Administration » Sysdba logging as another user

Home » RDBMS Server » Server Administration » Sysdba logging as another user

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sysdba logging as another user [message #242786]

Tue, 05 June 2007 02:04

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

Report message to a moderator

Re: Sysdba logging as another user [message #242795 is a reply to message #242786]

Tue, 05 June 2007 02:29

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Sysdba logging as another user [message #242877 is a reply to message #242786]

Tue, 05 June 2007 06:50

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 ?

Report message to a moderator

Re: Sysdba logging as another user [message #242880 is a reply to message #242877]

Tue, 05 June 2007 07:04

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Sysdba logging as another user [message #242925 is a reply to message #242786]

Tue, 05 June 2007 09:18

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Ram, another option is to connect as 'OPS$<OSUSERNAME>'

Report message to a moderator

Previous Topic:	DBMS job hanging
Next Topic:	Generating STATISTICS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:40:54 CDT 2024