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