SYSROLES
From Lianjapedia
Revision as of 06:46, 20 October 2014 by Yvonne.milne (Talk | contribs)
Contents
Purpose
System table for user and role information
See Also
MD5(), USERDOMAIN(), USEREMAIL(), USERNAME(), USERROLES(), 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. |
| 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. |
| ROLES | C | 255 | Roles: Comma-separated list of roles for the user. '*' means all. |
| C | 80 | Email: User's email address. | |
| NAME | C | 80 | Name: Full name of the user. |
Example
select * from system!sysroles
