The SYSUSERS table stores user credentials when NATIVE authentication is enabled.
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.
| 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. |