Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In Oracle, is sysman is the most powerful user or are there other equally privileged users?

share|improve this question

Any user with SYSDBA privilege is your "most powerful" user. They are on equal footing. The owner of the data dictionary, SYS, is the "classic" superuser in Oracle.

BTW, SYSMAN is not a SYSDBA user by default:

C:\>sqlplus sysman@db as sysdba

SQL*Plus: Release - Production on Tue Apr 27 10:27:15 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter password:
ORA-01031: insufficient privileges

Enter user-name:

If you are able to use OS authentication, it overrides password authentication:

C:\>sqlplus /nolog

SQL*Plus: Release - Production on Tue Apr 27 10:30:04 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

SQL> conn sysman as sysdba
Enter password:
SQL> select user from dual;


share|improve this answer
SYSMAN is the owmer of the enterprise manager repository – Robert Merkwürdigeliebe Apr 28 '10 at 7:49
And it's not a SYSDBA user by default. – DCookie Apr 28 '10 at 13:32

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.