Oracle PL/SQL/User Previliege/Revoke Permission

Revoke Permissions

   <source lang="sql">
  

SQL> SQL> SQL> CREATE USER Alice IDENTIFIED BY simplepassword; User created. SQL> SQL> GRANT SELECT, INSERT ON emp TO Alice WITH GRANT OPTION; SQL> SQL> REVOKE INSERT ON emp FROM Alice; SQL> SQL> SQL> drop user alice; User dropped. SQL>

 </source>
   
  

Revoke Permissions with Cascade

   <source lang="sql">
  

SQL> SQL> SQL> CREATE USER Alice IDENTIFIED BY simplepassword; User created. SQL> SQL> GRANT SELECT, INSERT ON emp TO Alice WITH GRANT OPTION; SQL> SQL> SQL> REVOKE INSERT ON emp FROM Alice CASCADE; SQL> SQL> drop user alice; User dropped. SQL>

 </source>
   
  

Revoking Object Privileges

   <source lang="sql">
 

REVOKE SELECT, INSERT ON ods_process FROM tester;

 </source>