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

Oracle NOARCHIVELOG & ARCHIVELOG Mode
List / Find Users in Oracle
Start Oracle Database in Mount Mode
OPatch: Prerequisite check "CheckActiveFilesAndExecutables"
© 2017 ITsiti. All Rights Reserved
Powered by KEEM