SET SESSION AUTHORIZATION statement (Change connected user)
Function
The SET SESSION AUTHORIZATION statement posts an authorization identifier and a password to HiRDB to make a change in the users who are connected.
Privileges
These users can change connected users.
Format
SET SESSION AUTHORIZATION {:embedded variable-1|?-parameter-1}
[{USING|IDENTIFIED BY} {: embedded variable-2|?-parameter-2 }]
Operands
Specifies an embedded variable or ? parameter that has an authorization identifier as its value.
If the UAP is written in C, specify a fixed-length character string of up to 31 bytes, the final character of which is the null value. If the character string does not terminate with the null value, the character string occupying (area length - 1) is used as the authorization identifier.
If the UAP is written in COBOL, specify a fixed-length character string of up to 30 bytes; this character string need not terminate with the null value.
If the character strings are to be case sensitive, enclose them in quotation marks (").
Specifies an embedded variable or ? parameter that contains a password as its value.
If the UAP is written in C, specify a fixed-length character string of up to 31 bytes, the final character of which is the null value. If the character string does not terminate with the null value, the character string occupying (area length - 1) is used as the password.
If the UAP is written in COBOL, specify a fixed-length character string of up to 30 bytes; this character string need not terminate with the null value.
Common rules