Share via


User System Table

[This topic is prerelease documentation and is subject to change in future releases. Blank topics are included as placeholders. There may be some display and formatting issues until the look and feel is finalized.]

The User system table gives you an overview of the user IDs with database logons that you have created for users in your database. Each record in the User table defines a single user ID.

The User table contains information about the password (displayed in encrypted form), the real name of the user, and how long the user's ID is valid for each user ID defined in your database. If you have the appropriate permissions, you can create new user IDs by entering the appropriate data in the User table. You can also remove a user ID by deleting the record from this table.

Deleting a Record

If you delete a record in the User system table, the corresponding entries in the Member Of system table are automatically deleted.

See Also

Concepts

System Tables