Home » SQL & PL/SQL » SQL & PL/SQL » Can DBA log in to any schema ? (Oracle 10g)
Can DBA log in to any schema ? [message #316506] Fri, 25 April 2008 07:23 Go to next message
hidnana
Messages: 87
Registered: November 2007
Location: chennai
Member
Can dba log in to any schema without the password ?
If so what is the command to connect from unizx script ?
Currently I use this command to connect...
sqlplus -s <<eof
$DB_USER/$DB_PASSWORD@$DBCONN

What will the command change to ?

From where will the password be retrieved for him ?


Re: Can DBA log in to any schema ? [message #316509 is a reply to message #316506] Fri, 25 April 2008 07:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Yes.
2/ He has to grant him to privilege to do it.
3/ The command is :
connect DBA[$DB_USER]/DBA_PASSWORD@$DBCONN
so if your purpose is to hide password, this fails as it exposes DBA password which is worse than user password.

Regards
Michel

Re: Can DBA log in to any schema ? [message #316515 is a reply to message #316509] Fri, 25 April 2008 08:11 Go to previous messageGo to next message
hidnana
Messages: 87
Registered: November 2007
Location: chennai
Member
Is this the case if OS authentication is enabled in the DB ?
Re: Can DBA log in to any schema ? [message #316535 is a reply to message #316515] Fri, 25 April 2008 10:35 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When you give a password OS authentication is irrelevant.
So answer is it does not care.

Regards
Michel

[Updated on: Fri, 25 April 2008 10:35]

Report message to a moderator

Previous Topic: When to use partition indexes?
Next Topic: ora-00600 during select query execution...
Goto Forum:
  


Current Time: Thu Dec 08 18:24:27 CST 2016

Total time taken to generate the page: 0.05122 seconds