René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
Password file authentication vs OS authentication in Oracle | ||
OS authentication
It's possible to have the operating system check if a user may log on a database or not. The idea is, if the
user already knew the password to log on to the operating system, he doesn't have to know a password on the
database. Such a user is created like so:
create user ops$<os_username> identified externally
Note, the string ops$ must be identical to the value of
os_authent_prefix.
|