authmech

Description

Determines what authentication mechanism is used by a specified logged in server process ID.

Syntax

authmech ([spid])

Examples

Example 1

Returns the authentication mechanism for server process ID 42, whether KERBEROS, LDAP, or any other mechanism:

select authmech(42)

Example 2

Returns the authentication mechanism for the current login’s server process ID:

select authmech()

or

select authmech(0)

Example 3

Prints the authentication mechanism used for each login session:

select suid, authmech(spid)
    from sysprocesses where suid!=0

Usage

• This function returns output of type varchar from one optional argument.

• If the value of the server process ID is 0, the function returns the authentication method used by the server process ID of the current client session.

• If no argument is specified, the output is the same as if the value of the server process ID is 0.

• Possible return values include ldap, ase, pam, and NULL.

Permissions

Any user can execute authmech to query a current personal session. You must have sso_role privileges to query the details of another user’s session.