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

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

Revoke Permissions with Cascade

   
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>

   
    
    
  

Related examples in the same category