Difference between revisions of "SYSPERMS"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 3: | Line 3: | ||
==See Also== | ==See Also== | ||
| − | [[ | + | [[Guide to the Users Workspace (Video)]], [[MD5()]], [[SET ROWFILTER]], [[SYSDATAMASKS]], [[SYSROLES]], [[SYSROWFILTERS]], [[:Category:System Tables|System Tables]], [[USERDATAMASK()]], [[USERROWFILTER()]], [[Users and Roles]] |
==Description== | ==Description== | ||
Revision as of 08:13, 24 February 2017
Contents
Purpose
System table for dynamic role information
See Also
Guide to the Users Workspace (Video), MD5(), SET ROWFILTER, SYSDATAMASKS, SYSROLES, SYSROWFILTERS, System Tables, USERDATAMASK(), USERROWFILTER(), Users and Roles
Description
The sysperms table is stored in the system database and 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
