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.