Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / User Privilege

 

Grant with admin option

SQL> SQL> create user demo_ddl identified by demo_ddl; User created. SQL> SQL> grant connect, resource to demo_ddl with admin option; Grant succeeded. SQL> SQL> grant create user to demo_ddl; Grant succeeded. SQL> grant drop user to demo_ddl; Grant succeeded. SQL> SQL> --@connect demo_ddl/demo_ddl SQL> SQL> drop user demo_ddl cascade; User dropped. SQL>