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

V$ARCHIVE: Redo Log Files for Archiving
V$BACKUP_CORRUPTION: Datafile Backup Corrupt Block Ranges
ORA-28011: the account will expire soon; change your password now
Check Response Time & Runtime of Oracle SQL Statement
© 2017 ITsiti. All Rights Reserved
Powered by KEEM