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};
Permissions
If the specified roles have security audit attributes, the session must also have MAINTAIN_AUDIT privilege.
Related Statements
CREATE ROLE
GRANT (privilege)
Last modified date: 08/14/2024