SYSUSERS system table The SYSUSERS table stores user credentials when NATIVE authentication is enabled. system tablesSYSUSERS database credentialsSYSUSERS system table SYSUSERS system table

When SQL authorization is enabled (as it is, for instance, when NATIVE authentication is on) only the database owner can SELECT from this table, and no one, not even the database owner, can SELECT the PASSWORD column.

The following table shows the contents of the SYSUSERS system table.

SYSUSERS system tableFor each column in the SYSUSERS system table, this table provides its data type, its length in bytes, whether it is nullable, and a description of its contents. Column Name Type Length Nullable Contents USERNAME VARCHAR 128 false The user's name, the value of the user attribute on a connection URL. HASHINGSCHEME VARCHAR 32672 false Describes how the password is hashed. PASSWORD VARCHAR 32672 false The password after applying the HASHINGSCHEME. LASTMODIFIED TIMESTAMP 29 false The time when the password was last updated.