Home » RDBMS Server » Server Administration » Confusion over DBA authentication
Confusion over DBA authentication [message #297136] Wed, 30 January 2008 04:50 Go to next message
Messages: 28
Registered: March 2007
Junior Member
I learnt that DBAs in an Oracle database are identified by either password files or through OS authentication.
Now, if a database is created with the pfile parameter REMOTE_PASSWORD_FILE=NONE, then how are DBA identifies if there is also no OS authentication?
Re: Confusion over DBA authentication [message #297139 is a reply to message #297136] Wed, 30 January 2008 05:08 Go to previous messageGo to next message
Messages: 3202
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
They aren't.

Unless they wear a baseball cap or t-shirt that says "DBA" on it. Razz

But that would only matter to their colleagues, not to the database.

Or do you have an example where someone managed to connect as sysdba without a password file or OS authentification?


Or perhaps you meant the DBA role, not the sysdba login. They are two different things, and that might be the source of your confusion. The DBA role can be granted to normal oracle user logins.

[Updated on: Wed, 30 January 2008 05:20]

Report message to a moderator

Re: Confusion over DBA authentication [message #297145 is a reply to message #297136] Wed, 30 January 2008 05:38 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Concepts
Chapter 20 Database Security
Section Overview of Authentication Methods

99% of your questions are answered in this book.
Previous Topic: Error during starting a database
Next Topic: regarding oracle architecture
Goto Forum:

Current Time: Sun Aug 20 23:52:22 CDT 2017

Total time taken to generate the page: 0.05899 seconds