3 Replies Latest reply on Nov 1, 2015 5:57 PM by thatJeffSmith-Oracle

    ORA-01031: insufficient privileges, when granting system privileges to a new user



      While logged in a SYSTEM, I'm trying to create a new user and grant him all the system privileges, but doing so always shows up the following error:

      Failed to process SQL command


      Error starting at line : 123 in command -

      GRANT SYSDBA TO TestUser

      Error report -

      SQL Error: ORA-01031: insufficient privileges

      01031. 00000 -  "insufficient privileges"

      *Cause:    An attempt was made to perform a database operation without

                 the necessary privileges.

      *Action:   Ask your database administrator or designated security

                 administrator to grant you the necessary privileges

      After clicking okay, the user is still being created but missing many system privileges.

      How can I solve this issue?


      I'm using Oracle SQL Developer version, and Oracle database 11g express edition.