Checking authentication type of users

You can check whether a user is authenticated internally (includes token-based authentication) or externally by querying the SYS_USERS system table.

Procedure

Use the following statement to check the authentication type of all users:

SELECT ID, NAME, AUTHENTICATION FROM SYS_USERS;

The column AUTHENTICATION contains information about the authentication type of the user:

▪ 0 – default (internal) authentication (includes token-based authentication)

▪ 1 – external authentication

Example

solsql> SELECT ID, NAME, AUTHENTICATION FROM SYS_USERS;

ID NAME      AUTHENTICATION
-- ----      --------------
1 DBA       0
2 OMEGA     1
9 PELLE     1
3 rows fetched.

Go up to