Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / User Privilege

 

Granting Object Privileges to a User

GRANT SELECT, INSERT,  UPDATE ON schemaName.objectName TO userName; GRANT SELECT ON store.employees TO userName; GRANT UPDATE (last_name, salary) ON store.employee TO userName;