| Confusion over DBA authentication [message #297136] |
Wed, 30 January 2008 04:50  |
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  |
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. 
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
