Expansion of Authorization-identifier

The expanded parameters of authorization-identifier represent user identifiers or group identifiers in an SQL authorization statement.
idmscu
The expanded parameters of authorization-identifier represent user identifiers or group identifiers in an SQL authorization statement.
Syntax
Expansion of authorization-identifier
►►─┬─ user-identifier ──┬─────────────────────────────────────────────────────►◄    └─ group-identifier ─┘
 
Parameters
  • user-identifier
    Identifies a user defined to the security system.
  • group-identifier
    Identifies a group defined to the security system.
 
Examples
Authorizing a User to Update a Table
In the following GRANT statement, the authorization identifier is the user identifier RES:
grant update    on table employee    to res;
Revoking Execute Privileges from a Group
In the following REVOKE statement, the authorization identifier is the group identifier ACCT_GRP_1:
revoke execute    on access module am88pr08    from acct_grp_1;