GRANT

The GRANT statement allows to manage users and permissions.

General format

EXEC SQL [AT Database]     GRANT Options   END-EXEC

Syntax rules

1.	Options is passed to the driver without further checks. Refer to the database documentation for detailed syntax. Syntax errors, if any, are returned at runtime.

General Rules

1.	Database identifies the active connection that will execute the query and must be previously defined using a Format 4 DECLARE statement.

Examples

Grant Select and Insert access privilege to a table to some users

exec sql      grant select, insert on invoices         to  usr1, erollands end-exec