Difference between revisions of "SYSPERMS"
From Lianjapedia
Yvonne.milne (Talk | contribs) (→Description) |
Yvonne.milne (Talk | contribs) |
||
Line 35: | Line 35: | ||
[[Category:Users and Roles]] | [[Category:Users and Roles]] | ||
[[Category:Reference]] | [[Category:Reference]] | ||
+ | [[Category:System Tables]] |
Latest revision as of 09:40, 22 April 2020
Contents
Purpose
System table for dynamic role information
See Also
Guide to the Users Workspace (Video), MASKEDDATA(), MD5(), SET ROWFILTER, SYSDATAMASKS, SYSROLES, SYSROWFILTERS, System Tables, USERDATAMASK(), USERDOMAIN(), USEREMAIL(), USERNAME(), USERROLES(), USERROWFILTER(), Users and Roles, Users Tables
Description
The sysperms table is stored in the system database and contains dynamic role information.
Column | Data Type | Width | Description |
---|---|---|---|
ROLE | C | 60 | Role Group |
APP | C | 40 | App |
UICONTROL | C | 80 | UI Control |
PERMCREATE | L | 1 | Create |
PERMREAD | L | 1 | Read |
PERMUPDATE | L | 1 | Update |
PERMDELETE | L | 1 | Delete |
Example
select * from system!sysperms