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

Thread: Everyone can be promoted as a sysdba?

  1. #1
    Join Date
    Oct 2001
    Location
    Singapore
    Posts
    4

    Cool

    I have installed Oracle 8.1.5.0.0 on Windows NT 4.0.
    In SQL*Plus, I find a very strange phenomenon: Every user (even a very common one) can be promoted as a sysdba by the following simple command:

    connect / as sysdba;

    Then the user is able to act as the super-user sys and even shutdown the database.

    It means that there is not any security for the DB? I doubt that there must be some mechanism to prevent it.





    moonriver

  2. #2
    Join Date
    Sep 2001
    Posts
    112
    I think your probably doing it on your machine.

    connect / as sysdba is (i think) OS authenticated. If your logged on as a system administrator then you can log on as sysdba.

    If you try logging onto NT as non sys-admin and try again to test this.

  3. #3
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    sysdba is a very special role which can only be granted to specefic users by the 'internal' user who creates (and therefore knows the password) the password file.
    Not everyone can connect as sysdba.
    If it is happening, it is because of implementing OS authentication in which any user logging in the OS as a priveleged system administrator is automatically granted the sysdba role in Database.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

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