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.