Was this helpful?
GRANT (role)
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The GRANT (role) statement controls additional access to role objects created by the CREATE ROLE command. (When a role is created, an implicit grant is issued on the role to the user creating the role.) Role access can only be granted to specific users or to public.
The GRANT (role) statement has the following format:
[EXEC SQL] GRANT role {, role}
              TO PUBLIC | [USER] auth_id {, auth_id};
GRANT (role) Example
Enable the user, bspring, to access sysop role:
GRANT sysop TO bspring
Last modified date: 05/15/2024