Difference between revisions of "SYSROWFILTERS"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "==Purpose== System table for role based row level filters ==See Also== MD5(), SYSPERMS, SYSROLES, USERDOMAIN(), USEREMAIL(), USERNAME(), USERROLES()...") |
Yvonne.milne (Talk | contribs) |
||
(5 intermediate revisions by the same user not shown) | |||
Line 3: | Line 3: | ||
==See Also== | ==See Also== | ||
− | [[MD5()]], [[SYSPERMS]], [[SYSROLES]], [[USERDOMAIN()]], [[USEREMAIL()]], [[USERNAME()]], [[USERROLES()]], [[Users and Roles]], [[Users Tables]] | + | [[Guide to the Users Workspace (Video)]], [[MD5()]], [[SET ROWFILTER]], [[SYSDATAMASKS]], [[SYSPERMS]], [[SYSROLES]], [[:Category:System Tables|System Tables]], [[USERDATAMASK()]], [[USERDOMAIN()]], [[USEREMAIL()]], [[USERNAME()]], [[USERROLES()]], [[USERROWFILTER()]], [[Users and Roles]], [[Users Tables]] |
==Description== | ==Description== | ||
Line 22: | Line 22: | ||
|- | |- | ||
|} | |} | ||
− | |||
− | |||
==Example== | ==Example== | ||
Line 34: | Line 32: | ||
[[Category:Reference]] | [[Category:Reference]] | ||
[[Category:Lianja v3.4]] | [[Category:Lianja v3.4]] | ||
+ | [[Category:System Tables]] |
Latest revision as of 09:42, 22 April 2020
Contents
Purpose
System table for role based row level filters
See Also
Guide to the Users Workspace (Video), MD5(), SET ROWFILTER, SYSDATAMASKS, SYSPERMS, SYSROLES, System Tables, USERDATAMASK(), USERDOMAIN(), USEREMAIL(), USERNAME(), USERROLES(), USERROWFILTER(), Users and Roles, Users Tables
Description
The sysrowfilters table is stored in the system database and holds role based row level filter information.
Column | Data Type | Width | Description |
---|---|---|---|
DOMAIN | C | 80 | Domain: Domain or tenancy for the user. |
DATABASE | C | 80 | Database: Name of the database. |
TABLE | C | 80 | Table: Name of the table. |
ROLE | C | 80 | Role: Name of the role. |
ROWFILTER | M | 8 | Row Filter: Filter condition. |
Example
select * from system!sysrowfilters