-
Manage Passwords across multiple databases
Hi,
We have the same users connecting multiple database. A lot of them have differennt passwords but the same username. Whats the best way to have a system where the passwords across all the 3 databases are synced up.
Detail
-------
We have 3 databases
A, B and C and the emplyees of our company have accounts in all of
them. We plan to write a front end so that they can manage the passwrds
themselves rather than letting the DBA do that.
That is they will have a User Interface where they can modify the
password and that will update the password in all the 3 instances. This
will ensure that the passwords are always same cross different
applications accessing different databases.
Its easy to write a procedure which can do this to a database where the
password management application resides. How does one go about updating
the user passwords in the remore database using stored procedure.
Thanks
Ron
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
Below is a lousy way to accomplish it. Idea being - find a way to replicate the hash value across.
C:\Documents and Settings\Administrator>set ORACLE_SID=TEST
C:\Documents and Settings\Administrator>sqlplus "sys as sysdba"
SQL*Plus: Release 9.2.0.6.0 - Production on Fri May 20 17:02:02 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
SQL> create user axr2 identified by blah;
User created.
SQL> select password from dba_users where username='AXR2';
PASSWORD
------------------------------
75F58177277738EB
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
C:\Documents and Settings\Administrator>sqlplus system@PRODDB.APOLLOJR
SQL*Plus: Release 9.2.0.6.0 - Production on Fri May 20 17:02:58 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
SQL> alter user axr2 identified by values '75F58177277738EB';
User altered.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
C:\Documents and Settings\Administrator>sqlplus axr2/blah@PRODDB.APOLLOJR
SQL*Plus: Release 9.2.0.6.0 - Production on Fri May 20 17:03:37 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
SQL>
Last edited by Axr2; 05-20-2005 at 05:09 PM.
-
How do we accomplish this from a stored procedure.
We are planning to provide a GUI environment to our users using plsql webtoolkit.
Thanks
Ron
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|