Printable View
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:
Could you please elaborate little bit on this. I haven't read anythung about it anywhere. Thanks
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...
Actually, I stand corrected.
Security server was introduced with 8.0, not 8.1. You can read about it at:
http://technet.oracle.com/docs/produ.../ch3.htm#88362
and learn how to implement it at:
http://technet.oracle.com/docs/produ...cts.htm#438330
Oracle & LDAP can be found at:
http://technet.oracle.com/docs/produ...tro.htm#996870
And RADIUS authenication can be found at:
http://technet.oracle.com/docs/produ...acces.htm#5616
Thanks a lot. I appreciate it.
Jeff,
Thanks for the info.