Revoke Permissions : Revoke Permission « User Previliege « Oracle PL / SQL

1. Oracle PL / SQL
2. User Previliege
3. Revoke Permission

Revoke Permissions

   
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>

   
    
    
  

Related examples in the same category