Name
set_user_id — sets the current user for execution
Synopsis
integer
set_user_id
(
|
in user_name varchar , |
| in mode integer , | |
in
password
varchar
); |
Description
This function changes the effective user and group to that of the user defined by user_name parameter. When called by a user with DBA group privileges, the optional password may be omitted. Otherwise it has to be the valid password for user_name. The mode parameter determines persistence (context) of effects of the call: If omitted or set to integer value 1, the effective user privileges will remain in effect within current stored procedure context only - upon returning, the effective user privileges will be automatically reset to state effective before set_user_id. When mode is equal to integer value 0, the effective user privileges will remain set for duration of current ODBC session, current request in web server context, or until next call of set_user_id. This function is analogous to the UNIX 'su' command.
Parameters
user_name
the name of SQL user account to be used as effective user and group.
mode
optional, integer 1 (default) means change of privileges remains in effect only while within current stored procedure context.
password
this optional parameter is needed if calling the function without DBA privileges. Password of the user user_name
.
Return Types
No return value