1 Reply Latest reply: Mar 7, 2013 2:36 AM by Roger Ford-Oracle RSS

    Oracle DB 11.2.0.1.0 takes any password for sys user

    sheeja.anil
      Hi,

      My Oracle DB installation (11.2.0.1.0) takes any password for the sys user.
      Any idea why ?

      I didn't try changing password.
      Need to find out is that any steps I missed in installation.
      Is there any option like that it can login with any password ?

      Please share your experience.
        • 1. Re: Oracle DB 11.2.0.1.0 takes any password for sys user
          Roger Ford-Oracle
          Not really an Oracle Text question, but I think I can answer it anyway.

          When you do the install, it asks you for the operating system group for the Oracle owner. This is usually known as the "dba" group, and traditionally it was fixed to a group actually called "dba", but these days can be any group.

          Any user who is in this group can logon as SYS without specifying a password - and if a password is specified, it can be anything.

          That's the situation on Unix/Linux, anyway - on Windows I suspect it's just the user who installed the software who has these rights.

          Not sure it's possible to change the dba group after installation, but a Google search for "oracle change dba group" turns up a promising list of results.