Wednesday, 5 June 2013

Oracle DB and OS users authorized in to it #whatIlearned #en

Still little messy for me ... but I hope I get it right (we had argument with my colleague about this even after reading page in reference)

When you need to check what users from your OS can access Oracle DB, you should first go to Oracle and submit command:
SHOW PARAMETER os_authent_prefix
you will find prefix for users OS authorized to DB, then you can list all users in your DB. Any user with this prefix is OS user with rights to access DB.

If you wanted know more, there is nice page:
http://www.oracle-base.com/articles/misc/os-authentication.php

No comments:

Post a Comment