Home » RDBMS Server » Security » Two password for one user
Two password for one user [message #175583] Sat, 03 June 2006 02:00 Go to next message
mann
Messages: 3
Registered: May 2006
Location: Thimphu
Junior Member

Hi,
How I want to keep two password for one user.
For example
SQL> alter user scott identified by tiger;

Now i want two person to give secret password seperately as follows:

SQL> alter user scott identified by password1 || password2;

Note: For the user scott the password1 and password2 should be kept by two different person. While loggin to the database through SQL the password1 and password2 should be entered by two different person.

Please help me!!!
Re: Two password for one user [message #175602 is a reply to message #175583] Sat, 03 June 2006 04:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>How I want to keep two password for one user.
Not possible.
You can create two different users and make them look alike (sharing the same objects) and make your everyday life more complex. But not possible to do what you are seeking after.
Re: Two password for one user [message #175640 is a reply to message #175583] Sat, 03 June 2006 16:28 Go to previous messageGo to next message
rsaluj
Messages: 13
Registered: May 2006
Junior Member
It is not possible to assign two passwords for one user, I don't know why u want to do, but you can assign same password to different users.
Re: Two password for one user [message #175838 is a reply to message #175640] Mon, 05 June 2006 12:27 Go to previous messageGo to next message
feroze
Messages: 144
Registered: September 2005
Location: chicago
Senior Member
It seems the OP wants to impelement the practical things done banks locker same with Oracle, As in a bank locker, it can't be opened with a single key, 2 keys are required,

This is not possible here,
I wish some one from Oracle could read this requirement and try to implement in future release, Till the Wait and Watch. Cool


Regards
Re: Two password for one user [message #175936 is a reply to message #175838] Tue, 06 June 2006 02:56 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Hmmmm, you could, I suppose, do the following.

Revoke all priviledges from user Scott except for the Create Session Priviledge.
Create a password protected role that has all of the required priviledges for Scott.

Person 1 logs in as Scott with main password.
Person 2 takes over and activates the appropriate role with the password for that role.

Scott now has priviledges active.


HTH
Jim
icon7.gif  Re: Two password for one user [message #175971 is a reply to message #175602] Tue, 06 June 2006 04:30 Go to previous message
mann
Messages: 3
Registered: May 2006
Location: Thimphu
Junior Member

Thank you for the reply!!!
Previous Topic: Auditing XML, Extended
Next Topic: Tracking All users SQL stmts as SYS and SYSTEM user
Goto Forum:
  


Current Time: Thu Mar 28 16:15:05 CDT 2024