Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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 ?

like image 467
HalfWebDev Avatar asked Feb 26 '12 18:02

HalfWebDev


2 Answers

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;
like image 185
Joachim Isaksson Avatar answered Sep 24 '22 07:09

Joachim Isaksson


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

like image 21
Kamil Avatar answered Sep 25 '22 07:09

Kamil