This discussion is archived
3 Replies Latest reply: Feb 1, 2013 5:40 AM by Osama_Mustafa RSS

connecting without authenticating

413827 Newbie
Currently Being Moderated
When I issue the following commands in sqlplus in oracle 11g Rel2 in solaris

connect sys/wrong password as sysdba
connect ja;dslfjas;dfjas;/kj;asdkjf;asdk as sysdba
it is connecting both at idle state as well as at open state also.
Why it is happening so and how to rectify this problem.
  • 1. Re: connecting without authenticating
    Mark Williams-Oracle Employee ACE
    Currently Being Moderated
    ravi02 wrote:
    When I issue the following commands in sqlplus in oracle 11g Rel2 in solaris

    connect sys/wrong password as sysdba
    connect ja;dslfjas;dfjas;/kj;asdkjf;asdk as sysdba
    it is connecting both at idle state as well as at open state also.
    Why it is happening so and how to rectify this problem.
    It is happening because you are logged into the o/s using an account that is a member of the dba o/s group.

    It is not a problem to be rectified. It is working as designed.

    EDIT1:

    Rob's pointed you to the docs and Osama's solution will necessitate a valid username/password to be used. This means that the following will no longer work:

    SQL> connect / as sysdba

    That may be what you want or not. But, as I said initially, things are functioning as designed it's a matter of configuration.

    Edited by: Mark Williams on Feb 1, 2013 12:57 PM
  • 2. Re: connecting without authenticating
    Rob_J Journeyer
    Currently Being Moderated
    Read the documentation about [url http://docs.oracle.com/cd/E11882_01/server.112/e25494/dba006.htm#sthref74]authentication for SYS user
  • 3. Re: connecting without authenticating
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    to prevent this add the below line to sqlnet.ora
     SQLNET.AUTHENTICATION_SERVICES=(NONE)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points