authmech

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

Syntax

authmech ([spid])

Examples

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

The permission checks for authmech differ based on your granular permissions settings.

SettingsDescription
Granular permissions enabled

With granular permissions enabled, any user can execute authmech to query a current personal session. You must have select permission on authmech to query the details of another user’s session.

Granular permissions disabled

With granular permissions disabled, any user can execute authmech to query a current personal session. You must be a user with sso_role or have select permission on authmech to query the details of another user’s session.