Identifiers › Expansion of Authorization-identifier

Expansion of Authorization-identifier

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;