My Oracle Support Banner

FAQ: Database Authentication (Doc ID 2721097.1)

Last updated on JULY 21, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.

Goal

 This note tries to answer some of common Database authentication questions. It provides a "fast track" to set up and debug ORA errors with Database authentication, however, this is not meant as an exhaustive replacement of the official documentation.

Ask Questions, Get Help, And Share Your Experiences With This Article

Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?

Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article.
Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Security Products.

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 1. Why Can I Login AS SYSDBA With Any Username and Password?
 2. Can SYS password be changed using ALTER USER command?
 3. Is it supported to use OPS$ in 12c and above Database versions?
 4. How to restrict Database access through specific application or tool?
 5. How to restrict remote OS authentication?
 6. What Oracle client version can connect to What Oracle Database version?
 7. How to configure CMU Centrally Managed User authentication?
 8. How to implement implement Active Directory authentication for Database users?
 9. How to do proxy authentication?
 10. Why Database user login fails with ORA-1017 after upgrading to 12c DB?
 11. How to troubleshoot ORA-1031/ORA-1017 errors with sysdba login?
 12. Why some Users have null value in sys.user$.password column?
 13. How to store oracle database user's password safely in a wallet? How to do password authentication in script without exposing the password in trace/log files?
 14. Why Expdp/Impdp doesn't work with OS or External Password Store authentication?
 15. Why Database user logins are slow / taking more time to connect?
 16. Why DBA_USERS.ACCOUNT_STATUS shows LOCKED instead of LOCKED(TIMED), after FAILED_LOGIN_ATTEMPTS Is Breached?
 17. Why connection on Standby DB fails with 'ORA-28000: the account is locked', but the account_status is OPEN?
 18. How to change Oracle owner from Local System account to Domain user account in Oracle Database server on Windows OS?
 19. Why the Database user password change is failing with error 'ORA-00604: Error Occurred At Recursive SQL Level 1'?
 20. Why ptime, expiry_date is not updated for SYS user after applying July 2018 or later RU / PSU / DBBP ?
 21. What is schema-only accounts?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.