Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET

The GRANT (privilege) statement grants privileges on the database as a whole or on individual tables, views, sequences or procedures. It controls access to database objects, roles, and DBMS resources. Details about using the GRANT statement with role objects is described in Grant (role) (see page GRANT (role)).

To remove privileges, use the REVOKE statement. To determine the privileges in effect for a session, use the DBMSINFO function. In some cases granting a privilege imposes a restriction, and revoking the privilege removes the restriction. For example, GRANT NOCREATE_TABLE prevents the user from creating tables.

To display granted database privileges, select data from the iidbprivileges system catalog.