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
Muddassar
Messages: 28
Registered: March 2007
Junior Member
Hi,
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
ThomasG
Messages: 3189
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?

EDIT:

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: 64132
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.
Regards
Michel
Previous Topic: deletion of bdump .trc files
Next Topic: regarding oracle architecture
Goto Forum:
  


Current Time: Thu Dec 08 00:02:18 CST 2016

Total time taken to generate the page: 0.10192 seconds