Setup OID authenticated users for DB user globally identified users.
25419Apr 14 2006 — edited Jul 4 2008I keep reading that you can setup Globally Identified users in Oracle database that
are authenticated by OID. But it does not seem to work and I cannot find explicit
directions for setting this up. I assume there must be some OID/SSO site
configuration I am not aware of.
We have an AS 10g app, a DB 9.2, and Forms 10g application. I created an OID
user, Created a Globally Identified User in DB, but when I log into SSO, setup my
RAD with password "doesnotmatter", then the database login comes up with
invalid Username/Password.
Whats not right?
We have to use OID to get Case Sensitive Passwords and we can get it to login
to a normal user account with a valid matching password. However, passwords
must be expired every 30-90 days and the change in OID during login does not
go through to the DB account. OID does care but I can't have DB accounts sitting
around with passwords that never expire and OID can't change them. I'd rather
have DB accounts that cannot be logged into.
Any else sucessfully implemented OID and Globally Identified DB users or found a
way to change DB Password after login/change password to OID?