SYSPERMS
From Lianjapedia
Revision as of 09:40, 22 April 2020 by Yvonne.milne (Talk | contribs)
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
