Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2013
    Posts
    2

    Red face Unanswered: I think I've found a bug in oracle 11g

    The problem is that:
    I can connect with each password to my oracle 11g database.
    As follows:
    sqlplus sys/123 as sysdba
    or
    sqlplus sys/abcdef as sysdba
    or
    sqlplus sys/hi122 as sysdba
    or....
    Is this a bug?



  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    That's not a bug, it's documented behaviour.

    Quote Originally Posted by The Manual
    When you enter SYS or a slash (/) as the user name and provide the AS SYSDBA clause, your access is authenticated using operating system authentication. Operating system authentication uses your Windows, UNIX, or Linux host user account to authenticate you to Oracle Database. You must have logged in to the host computer with a user account that is a member of a special host user group. On UNIX and Linux, this user group is typically dba
    Quoted from: http://docs.oracle.com/cd/E11882_01/....htm#ADMQS0361
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    It behaved the same way in V10 Oracle
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Sep 2013
    Posts
    2
    Thanks for the tips
    very helpful

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •