Home » RDBMS Server » Security » Login as sysdba in local host (10g 10.2.0.3 on linux 64 bit)
Login as sysdba in local host [message #317288] Wed, 30 April 2008 06:33 Go to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Hi,
I can login as sysdba in local machine, by following

sql>/ as sysdba
but i want that whenever user login as sysdba locally, he must provide sys password as he provide in remote location.

Is it passible and how

Re: Login as sysdba in local host [message #317301 is a reply to message #317288] Wed, 30 April 2008 07:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is a FAQ answered almost each and every week.
Try a search BEFORE posting.

sqlnet.authentication_services=NONE

Regards
Michel

Re: Login as sysdba in local host [message #317318 is a reply to message #317301] Wed, 30 April 2008 08:23 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
But this parameter in SQL NET file can be changed if i have OS user password, so there is no other way

Re: Login as sysdba in local host [message #317320 is a reply to message #317318] Wed, 30 April 2008 08:30 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I can login as sysdba in local machine,

Quote:
But this parameter in SQL NET file can be changed if i have OS user password

If the first one is true, the condition of the second one is satisfied.

Regards
Michel

[Updated on: Wed, 30 April 2008 08:32]

Report message to a moderator

Previous Topic: read only user
Next Topic: Changing the privileges on executable files
Goto Forum:
  


Current Time: Sat Dec 10 22:05:47 CST 2016

Total time taken to generate the page: 0.04169 seconds