Difference between revisions of "SYSROLES"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) (→Description) |
||
| Line 18: | Line 18: | ||
|- | |- | ||
|PASSWORD||C||80||Password: Password for the user, case-sensitive. This is encrypted as an MD5 cryptographic key. | |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. | ||
|- | |- | ||
|ROLES||C||255||Roles: Comma-separated list of roles for the user. Empty or '*' means all. | |ROLES||C||255||Roles: Comma-separated list of roles for the user. Empty or '*' means all. | ||
Revision as of 07:39, 28 June 2017
Contents
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. |
| ROLES | C | 255 | Roles: Comma-separated list of roles for the user. Empty or '*' means all. |
| C | 80 | Email: User's email address. |
Example
select * from system!sysroles
