8. SQL Statements : CREATE ROLE
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The CREATE ROLE statement defines one or more role identifiers and their associated password. Role identifiers are used to associate privileges with applications. After the role identifiers are created and privileges have been granted to them, use them with the CONNECT statement to associate those privileges with the session. For information about the privileges granted to role identifiers, see Grant (role) (see GRANT (role)) .
Only users who have been granted access to a role can use a role. The creator of a role is automatically granted access to that role.