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: 3186
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: 63915
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: deletion of bdump .trc files
Next Topic: regarding oracle architecture
Goto Forum:

Current Time: Mon Oct 24 09:39:26 CDT 2016

Total time taken to generate the page: 0.05870 seconds