SYSROLES

From Lianjapedia
Jump to: navigation, search

Purpose

System table for user and role information

See Also

Guide to the Users Workspace (Video), MD5(), SET ROWFILTER, SYSDATAMASKS, SYSPERMS, SYSROWFILTERS, System Tables, USERDATAMASK(), USERDOMAIN(), USEREMAIL(), USERNAME(), USERROLES(), USERROWFILTER(), Users and Roles, Users Tables

Description

The sysroles table is stored in the system database and holds user and role information.

Column Data Type Width Description
DOMAIN C 80 Domain: Domain or tenancy for the user.
NAME C 80 Name: Full name of the user.
USERNAME C 80 Username: Name of the user, case-sensitive.
PASSWORD C 80 Password: Password for the user, case-sensitive. This is encrypted as an MD5 cryptographic key.
EXPIRES D 8 Expires: Expiration date for the user. Login or http request is rejected if a user's expiration date has passed. From v4.0.
ROLES C 255 Roles: Comma-separated list of roles for the user. Empty or '*' means all.
EMAIL C 80 Email: User's email address.

Example

select * from system!sysroles