This discussion is archived
1 Reply Latest reply: Mar 7, 2013 12:36 AM by Roger Ford RSS

Oracle DB 11.2.0.1.0 takes any password for sys user

sheeja.anil Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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.

Legend

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