User Privilege Oracle PLSQL Tutorial

An object privilege allows a user to perform certain actions on database objects, such as executing DML statements on tables.
Commonly Used Object Privileges
Object PrivilegeAllows a User to
SELECTPerform a select
INSERTPerform an insert
UPDATEPerform an update
DELETEPerform a delete
EXECUTEExecute a stored procedure