Grant & Revoke User Privileges in Oracle

Symptom

You want give select, update and insert privileges to a user in Oracle. At the same time, you also want to know how to revoke, remove all these privileges from a user.

Grant Privileges

1. You are giving privileges for user USER_ARA to select, update and insert for table TABLE_SITI.

SQL> grant select, update, insert on TABLE_SITI to USER_ARA;

Revoke Privileges

1. You are removing privileges for user USER_ARA to select, update and insert for table TABLE_SITI.

SQL> revoke select, update, insert on TABLE_SITI to USER_ARA;