GRANT (Object Privileges) command

This command gives users database object privileges.

Syntax

GRANT privilege., ..ON object_name
    TO { grantee., ...} | PUBLIC
    [ WITH GRANT OPTION ];
privilege ::= 
     { ALL PRIVILEGES }
     | { SELECT
         | DELETE
         | { INSERT [ ( column name.,..) ] }
         | { UPDATE [ ( column name.,..) ] }
         
object name ::=
         [ TABLE ] table name
Keyword Description
privilege Type of access, action, or privilege to grant:
  • ALL PRIVILEGES - Passes on all applicable privileges that you are entitled to grant. PUBLIC denotes all authorization IDs, present and future
  • SELECT, INSERT, UPDATE, and DELETE - Let grantees execute the statements of the same names on the object
object_name Name of the object on which to grant privileges
grantee User name(s) to allow privilege

Use

This statement gives grantees the right to perform specified actions on named objects. ( Grantee is the authorization ID that represents a user or group of users.)