Grant & Revoke User Privileges in Oracle



Share this article :

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;

Related posts

Find Oracle User Last Password Change Time
ORA-01012: not logged on
Set Column Size in SQLplus
ORA-12518: TNS:listener could not hand off client connection
© 2018 ITsiti. All Rights Reserved
Powered by KEEM