CODEWITHSUNDEEP
sqloracle-databaseprivileges
Esther Ndung'u
Esther Ndung'u

Reputation: 55

insufficient privileges error on oracle-sql

I am a student, doing a project and one of the questions is to create a user APT1050. However, i am getting an error.

SQL> create user APT identified by abc password expire;
create user APT identified by abc password expire
                              *
ERROR at line 1:
ORA-01031: insufficient privileges

Help?

Upvotes: 1

Views: 95

Answers (1)

Mureinik
Mureinik

Reputation: 312116

Apparently, the user you're using doesn't have the create user system privilege. You should use a different user that has this privilege, such as sys or system.

Upvotes: 2

Related Questions