Allows a user to temporarily assume (impersonate) the specific roles
and system privileges of another user.
Note:
The SET USER system privilege is two words; the SETUSER statement
is one word.
When you grant the SET USER system privilege, you can define the
scope of impersonation as:
- Any user in the database.
- Any user within a specified list of users
(target_users_list).
- Any user who is a member of one or more of the specified roles
(target_roles_list).
Grant this system privilege using the WITH ADMIN OPTION, WITH NO
ADMIN OPTION, or WITH ADMIN ONLY OPTION clause. If you do not specify a clause, the
default is WITH NO ADMIN OPTION.