Restrictions on role activation

The Security Administrator restricts the conditions under which a role may be activated by specifying a where clause on the grant role statement. Adaptive Server evaluates the condition expressed by the where clause when the role is activated, either automatically during login, or when processing the set role statement. See “Predicated role activation”.