authmech

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

Syntax

authmech ([spid])

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
```

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.

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

Settings	Description
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.