Setting the authentication mode for a role

You can control the activation of roles with the role's auth_mode attribute.

Valid values for the auth_mode attribute are:
NONE
No authentication necessary
INVOKER
Invokers must enter their own password. This is the default.
Enter the following command to force users to authenticate as themselves when assuming a given role:

chrole auth_mod=INVOKER role_name