Mega Code Archive

 

Categories / Oracle PLSQL / User Previliege

 

Add the additional ALL clause to a GRANT statement in order to grant all possible privileges

GRANT SELECT,INSERT,UPDATE,DELETE on EMPLOYEES TO oe; GRANT ALL ON EMPLOYEES TO oe; --