Difference between revisions of "SYSROLES"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
| + | System table for user and role information | ||
==See Also== | ==See Also== | ||
| − | [[MD5()]] | + | [[MD5()]], [[USERDOMAIN()]], [[USEREMAIL()]], [[USERNAME()]], [[USERROLES()]], [[Users and Roles]], [[Users Tables]] |
==Description== | ==Description== | ||
| − | + | The sysroles table is stored in the system database and holds user and role information. | |
{| class="wikitable" width="100%" | {| class="wikitable" width="100%" | ||
!Column||Data Type||Width||Description | !Column||Data Type||Width||Description | ||
|- | |- | ||
| − | |DOMAIN||C||80||Domain: | + | |DOMAIN||C||80||Domain: Domain or tenancy for the user. '*' means all. |
|- | |- | ||
|USERNAME||C||80||Username: Name of the user, case-sensitive. | |USERNAME||C||80||Username: Name of the user, case-sensitive. | ||
| Line 16: | Line 17: | ||
|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. | ||
|- | |- | ||
| − | |ROLES||C||255||Roles: Comma-separated list of roles for the user. | + | |ROLES||C||255||Roles: Comma-separated list of roles for the user. '*' means all. |
|- | |- | ||
|EMAIL||C||80||Email: User's email address. | |EMAIL||C||80||Email: User's email address. | ||
| Line 24: | Line 25: | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | + | select * from system!sysroles | |
</code> | </code> | ||
Revision as of 08:26, 1 October 2014
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. '*' means all. |
| 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. |
Example
select * from system!sysroles
