SYSROWFILTERS

From Lianjapedia
Jump to: navigation, search

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