Difference between revisions of "SYSROWFILTERS"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 3: | Line 3: | ||
==See Also== | ==See Also== | ||
− | [[DATAMASK()]], [[MD5()]], [[ROWFILTER()]], [[SYSDATAMASKS]], [[SYSPERMS]], [[SYSROLES]], [[USERDOMAIN()]], [[USEREMAIL()]], [[USERNAME()]], [[USERROLES()]], [[Users and Roles]], [[Users Tables]] | + | [[DATAMASK()]], [[MD5()]], [[ROWFILTER()]], [[SET ROWFILTER]], [[SYSDATAMASKS]], [[SYSPERMS]], [[SYSROLES]], [[USERDOMAIN()]], [[USEREMAIL()]], [[USERNAME()]], [[USERROLES()]], [[Users and Roles]], [[Users Tables]] |
==Description== | ==Description== |
Revision as of 06:46, 20 February 2017
Contents
Purpose
System table for role based row level filters
See Also
DATAMASK(), MD5(), ROWFILTER(), SET ROWFILTER, SYSDATAMASKS, SYSPERMS, SYSROLES, USERDOMAIN(), USEREMAIL(), USERNAME(), USERROLES(), 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. |
Supported from Lianja v3.4.
Example
select * from system!sysrowfilters