SYSPERMS
From Lianjapedia
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
