9. Extended Statements : Grant : Syntax
 
Share this page                  
Syntax
The GRANT (privilege) statement has the following format:
[EXEC SQL] GRANT ALL [PRIVILEGES] | privilege {, privilege}
              [ON [TABLE] [schema.]table_name
                           TO PUBLIC | auth_id {, auth_id}
              [WITH GRANT OPTION];
privilege
Specifies the type of privilege.
table_name
Specifies the name of the table for which the privilege is being defined.
PUBLIC
Grants the privilege to all users.
auth_id
Specifies the name of the users to which you are granting privileges.