|
|
|
Valid in: SQL, ESQL
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};
|
|
|
If the indicated roles have security audit attributes, the session must also have maintain_audit privilege.
|
|
|
|
|
|
The following example enables the user, bspring, to access sysop role:
grant sysop to bspring