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?

Report message to a moderator

- 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: 3212
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: 68758
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

Previous Topic: deletion of bdump .trc files
Next Topic: regarding oracle architecture
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 31 13:33:59 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.