OraFAQ Forum: Security » User SYS logged without password locally

Home » RDBMS Server » Security » User SYS logged without password locally (Oracle 10g RHEL5)

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

User SYS logged without password locally [message #355330]

Thu, 23 October 2008 14:09

marcossantos
Messages: 123
Registered: June 2008

Senior Member

Hi,
I note recently that user SYS
can log via SQLPLUS without
password locally.
For example:
SQL> conn sys as sysdba;
Enter password:
Connected.
SQL>

I don't typed the password, only press <enter>
when ask me.

How can I resolve this?

Marcos Santos

[Updated on: Thu, 23 October 2008 14:23]

Report message to a moderator

Re: User SYS logged without password locally [message #355346 is a reply to message #355330]

Thu, 23 October 2008 15:35

Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Search here for this FAQ.

Regards
Michel

Report message to a moderator

Re: User SYS logged without password locally [message #355347 is a reply to message #355330]

Thu, 23 October 2008 15:35

babuknb
Messages: 1734
Registered: December 2005
Location: NJ

Senior Member

Hello,

Enable below parameter


SQLNET.AUTHENTICATION_SERVICES= (NONE)

In %ORACLE_HOME under network/admin/sqlnet.ora

Babu

[Updated on: Thu, 23 October 2008 15:37]

Report message to a moderator

Previous Topic:	Error code for ORA-12645 (merged 3)
Next Topic:	Copy all object privileges to new schema user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 25 17:42:19 CDT 2023