Difference between revisions of "SYSPERMS"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 3: | Line 3: | ||
==See Also== | ==See Also== | ||
| − | [[SYSDATAMASKS]], [[SYSROLES]], [[SYSROWFILTERS]], [[:Category:System Tables|System Tables]], [[Users and Roles]], [[Guide to the Users Workspace (Video)]] | + | [[DATAMASK()]], [[MD5()]], [[ROWFILTER()]], [[SYSDATAMASKS]], [[SYSROLES]], [[SYSROWFILTERS]], [[:Category:System Tables|System Tables]], [[Users and Roles]], [[Guide to the Users Workspace (Video)]] |
==Description== | ==Description== | ||
Revision as of 05:45, 20 February 2017
Contents
Purpose
System table for dynamic role information
See Also
DATAMASK(), MD5(), ROWFILTER(), SYSDATAMASKS, SYSROLES, SYSROWFILTERS, System Tables, Users and Roles, Guide to the Users Workspace (Video)
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
