OraFAQ Forum: Security » Login as sysdba in local host

Home » RDBMS Server » Security » Login as sysdba in local host (10g 10.2.0.3 on linux 64 bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Wed, 30 April 2008 06:33

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

Report message to a moderator

Re: Login as sysdba in local host [message #317301 is a reply to message #317288]

Wed, 30 April 2008 07:05

Michel Cadot
Messages: 68421
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

Report message to a moderator

Re: Login as sysdba in local host [message #317318 is a reply to message #317301]

Wed, 30 April 2008 08:23

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

Report message to a moderator

Re: Login as sysdba in local host [message #317320 is a reply to message #317318]

Wed, 30 April 2008 08:30

Michel Cadot
Messages: 68421
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 02 06:45:18 CDT 2023