-
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?
-
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
-
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
-
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
-
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
-
Jeff
Thanks a lot. I appreciate it.
Reddy,Sam
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|