Home » RDBMS Server » Security » User SYS logged without password locally (Oracle 10g RHEL5)
User SYS logged without password locally [message #355330] Thu, 23 October 2008 14:09 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search here for this FAQ.

Regards
Michel
Re: User SYS logged without password locally [message #355347 is a reply to message #355330] Thu, 23 October 2008 15:35 Go to previous message
babuknb
Messages: 1736
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:
  


Current Time: Thu Mar 28 03:41:42 CDT 2024