| Login as sysdba in local host [message #317288] |
Wed, 30 April 2008 06:33  |
MIFI
Messages: 125
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  |
Michel Cadot
Messages: 15238
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
MIFI
Messages: 125
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 |
Michel Cadot
Messages: 15238
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
| 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]
|
|
|
]
Members
Search
Help
Register
Login
Home
