Difference between revisions of "SYSROLES"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| (19 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
| + | System table for user and role information | ||
==See Also== | ==See Also== | ||
| − | [[MD5()]] | + | [[Database Tenancies]], [[Guide to the Users Workspace (Video)]], [[MD5()]], [[SET ROWFILTER]], [[SYSDATAMASKS]], [[SYSPERMS]], [[SYSROWFILTERS]], [[:Category:System Tables|System Tables]], [[USERDATAMASK()]], [[USERDOMAIN()]], [[USEREMAIL()]], [[USERNAME()]], [[USERROLES()]], [[USERROWFILTER()]], [[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: | + | |valign="top"|DOMAIN |
| + | |valign="top"|C | ||
| + | |valign="top"|80 | ||
| + | |valign="top"|Domain: Domain or tenancy for the user.<br>See also [[Database Tenancies]]. | ||
| + | |- | ||
| + | |NAME||C||80||Name: Full name of the user. | ||
|- | |- | ||
|USERNAME||C||80||Username: Name of the user, case-sensitive. | |USERNAME||C||80||Username: Name of the user, case-sensitive. | ||
| Line 16: | Line 22: | ||
|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. |
|- | |- | ||
|EMAIL||C||80||Email: User's email address. | |EMAIL||C||80||Email: User's email address. | ||
| + | |- | ||
| + | |MOBILE||C||80||Mobile: User's cell/mobile number including country code. From v8.0. | ||
| + | |- | ||
| + | |ROLES||C||255||Roles: Comma-separated list of roles for the user. Empty or '*' means all. | ||
| + | |- | ||
| + | |OTC||C||6||OTC: Login passcode. Internal use. From v8.0. | ||
| + | |- | ||
| + | |OTCEXPIRY||T||8||OTC Expiry: Login passcode expiry. Internal use. From v8.0. | ||
|- | |- | ||
|} | |} | ||
| Line 24: | Line 38: | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | + | select * from system!sysroles | |
</code> | </code> | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
| − | |||
[[Category:Users and Roles]] | [[Category:Users and Roles]] | ||
[[Category:Reference]] | [[Category:Reference]] | ||
| + | [[Category:System Tables]] | ||
| + | [[Category:Lianja v8.0]] | ||
Latest revision as of 05:32, 15 August 2022
Contents
Purpose
System table for user and role information
See Also
Database Tenancies, 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. See also Database Tenancies. |
| 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. |
| C | 80 | Email: User's email address. | |
| MOBILE | C | 80 | Mobile: User's cell/mobile number including country code. From v8.0. |
| ROLES | C | 255 | Roles: Comma-separated list of roles for the user. Empty or '*' means all. |
| OTC | C | 6 | OTC: Login passcode. Internal use. From v8.0. |
| OTCEXPIRY | T | 8 | OTC Expiry: Login passcode expiry. Internal use. From v8.0. |
Example
select * from system!sysroles
