I have created a user, let's call him C##USER from sysdba. Now, I'm trying to create another user from C##USER. Problem is I keep getting the following error:
ORA-01031: insufficient privileges
I have granted C##USER all privileges and have set the default role to ALL. Nothing works yet…
Any ideas? Thanks in advance.
Best Answer
You just need a
CREATE USER
system privilege BUT don't forget to useCONTAINER
clause which should be set toALL
, if you omit this clause then the grantee will haveCREATE USER
system privilege on the current container.GRANT
When a common user account is created, the account is created in all of the open pluggable databases. So the user who is creating this new user must have
CREATE USER
system privilege on all containers.