Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / User Privilege

 

Rich and Brad are maintenance level users

SQL>  CREATE ROLE maintenance; Role created. SQL> SQL> CREATE USER rich identified by rich; User created. SQL> CREATE USER brad identified by brad; User created. SQL> GRANT CONNECT TO rich, brad; Grant succeeded. SQL> GRANT maintenance TO rich, brad; Grant succeeded. SQL> SQL> drop user rich; User dropped. SQL> drop user brad; User dropped. SQL> drop role maintenance; Role dropped.