Ability to Impersonate Another User

The SET USER system privilege allows a user to assume the exact roles and system privileges of (impersonate) another user. Once begun, impersonation of another user remains in effect until it is terminated or the current session ends.

To grant the SET USER system privilege:

Each grantee (user doing the impersonating) must be an existing user or role.
Each target user (user being impersonated) must be an existing user with a login password.
The grantor (user granting the system privilege) must have administrative rights to the SET USER system privilege.
Each grantee must have been granted at least all roles and system privileges with same or higher administrative options as the target user.

Note: Failure to meet the final condition does not prevent the system privilege from being granted to the user; it does, however, prevent the user from executing the SETUSER command to successfully impersonate another user.

Note: This functionality is not currently implemented in Sybase Control Center.

See these topics:

Administration: User Management and Security > Security Management > Impersonation