Mega Code Archive
Categories
/
Oracle PLSQL
/
User Previliege
Grant Permissions
SQL> SQL> CREATE USER Alice IDENTIFIED BY simplepassword; User created. SQL> SQL> GRANT SELECT, INSERT ON emp TO Alice WITH GRANT OPTION; SQL> SQL> drop user alice; User dropped. SQL> SQL> SQL> SQL>