CODEWITHSUNDEEP
sqloracle-databaseoracle11g
HalfWebDev
HalfWebDev

Reputation: 7648

Create user with admin option oracle 11g command not working

okay , This command is not working

create user username identified by password with admin option ;

It throws an error which says missing or invalid option

And i am logged in as system . I have tried searching Oracle docs and they have written the same command . what i am doing wrong here ?

Upvotes: 7

Views: 53268

Answers (3)

Tushar Gopale
Tushar Gopale

Reputation: 11

you don't need to give admin option if you are giving user DBA privilege ,DBA is the administrator Also you can combine both statements Creation of user with Grant privilege:

create user username identified by password grant DBA to username;

Note:Correct me if I am wrong.☺

Upvotes: 0

Joachim Isaksson
Joachim Isaksson

Reputation: 180917

You need to first create the user;

CREATE USER username IDENTIFIED BY password;

then separately grant privileges with ADMIN OPTION;

GRANT dba TO username WITH ADMIN OPTION;

Upvotes: 29

Kamil
Kamil

Reputation: 13931

"ADMIN OPTION" is a part of "GRANT" statement. You can't use it with "CREATE USER".

Upvotes: 3

Related Questions