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

Thread: Password synchronization

  1. #1
    Join Date
    Mar 2001
    Posts
    13

    Smile

    I am using 8.1.7 Oracle Database. I have a training and a production database. I am using the expire password feature on my production database allowing users to enter a password. Does anyone know of a way that I can replicate passwords from my production database to my training database so that they match up?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    1. select username, password from dba_users on your production box.
    2. Use the "alter user identified by values 'xxxxxx'" clause to update your training database.

    or, you could use one of oracle's single sign-on technologies for this purpose...
    Jeff Hunter

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    oracle's single sign-on technologies

    Jeff:

    Could you please elaborate little bit on this. I haven't read anythung about it anywhere. Thanks
    Reddy,Sam

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Oracle 8i has a feature called "Security Server" that allows you to authenticate once and have access to multiple databases.

    Oracle also has the ability to hook up to RADIUS or LDAP services via the Advanced Networking Option...
    Jeff Hunter

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Actually, I stand corrected.

    Security server was introduced with 8.0, not 8.1. You can read about it at:
    [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76962/ch3.htm#88362[/url]
    and learn how to implement it at:
    [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/network.817/a76933/products.htm#438330[/url]

    Oracle & LDAP can be found at:
    [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/network.817/a86101/intro.htm#996870[/url]

    And RADIUS authenication can be found at:
    [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76965/c25acces.htm#5616[/url]
    Jeff Hunter

  6. #6
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    Jeff

    Thanks a lot. I appreciate it.
    Reddy,Sam

  7. #7
    Join Date
    Mar 2001
    Posts
    13
    Jeff,
    Thanks for the info.

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