DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Manage Passwords across multiple databases

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577

    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.

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    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.

  3. #3
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    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
  •  


Click Here to Expand Forum to Full Width