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

    aaa11sssddd

      Hello.

      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 4.1.2.20, and Oracle database 11g express edition.