DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: 9i password file error

  1. #1
    Join Date
    Dec 2002
    Posts
    1

    Question 9i password file error

    Hi ,
    I am trying to know new features of 9i and one strange thing I have noticed is that I can get in as sys with any password as sysdba ,which tells me password file is not being checked for sys logins.
    I tried to recreate the password file but still the same.
    Please suggest.

  2. #2
    Join Date
    May 2002
    Posts
    2,645

  3. #3
    Join Date
    Sep 2002
    Posts
    376
    hi
    you need not have to type any password when u login as a user belonging to DBA group.

    $ connect ' / as sysdba'

    or

    sql>connect sys as sysdba

    It wont prompt u for any password

  4. #4
    That is some external role called OSDBA doing this trick.
    www.cnoug.org

Posting Permissions

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


Click Here to Expand Forum to Full Width