4. SQL Statements : GRANT (role)
 
Share this page                  
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.
This statement has the following format:
[EXEC SQL] GRANT role {, role}
              TO PUBLIC | [USER] auth_id {, auth_id};