add the additional ALL clause to a GRANT statement in order to grant all possible privileges : Grant Permission « User Previliege « Oracle PL / SQL






  1. Oracle PL / SQL
  2. User Previliege
  3. Grant Permission

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;



--








Related examples in the same category

1.Create a user and grant the permission
2.grant all on directory DirName to User
3.Grant permission to system
4.Grant update permission
5.Column-Level Object Privileges
6.Procedure, function, and package privileges: EXECUTE and DEBUG
7.Materialized view privileges: SELECT and QUERY REWRITE
8.Directory privileges: READ and WRITE
9.grant one type or all types of privileges at once on any given object.
10.Grant Permissions