OraFAQ Forum: Security » Two password for one user

Home » RDBMS Server » Security » Two password for one user

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

Two password for one user [message #175583]

Sat, 03 June 2006 02:00

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!!!

Report message to a moderator

Re: Two password for one user [message #175602 is a reply to message #175583]

Sat, 03 June 2006 04:07

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: Two password for one user [message #175640 is a reply to message #175583]

Sat, 03 June 2006 16:28

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.

Report message to a moderator

Re: Two password for one user [message #175838 is a reply to message #175640]

Mon, 05 June 2006 12:27

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

Report message to a moderator

Re: Two password for one user [message #175936 is a reply to message #175838]

Tue, 06 June 2006 02:56

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

Report message to a moderator

Re: Two password for one user [message #175971 is a reply to message #175602]

Tue, 06 June 2006 04:30

mann
Messages: 3
Registered: May 2006
Location: Thimphu

Junior Member

Thank you for the reply!!!

Report message to a moderator

Previous Topic:	Auditing XML, Extended
Next Topic:	Tracking All users SQL stmts as SYS and SYSTEM user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 10 16:24:37 CDT 2025