Difference between revisions of "Users Tables"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
(3 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
− | System tables containing users, roles and dynamic roles and permissions | + | System tables containing users, roles and dynamic roles and permissions. They are in the '''system''' database. |
==See Also== | ==See Also== | ||
− | [[:Category:System Tables|System Tables]], [[Users and Roles]], [[ | + | [[:Category:System Tables|System Tables]], [[Users and Roles]], [[Guide to the Users Workspace (Video)]] |
==Description== | ==Description== | ||
Line 10: | Line 10: | ||
{| class="wikitable" width="100%" | {| class="wikitable" width="100%" | ||
!Table||Remarks | !Table||Remarks | ||
+ | |- | ||
+ | |[[SYSDATAMASKS]]||Role based dynamic data masking | ||
|- | |- | ||
|[[SYSPERMS]]||Dynamic roles and permissions | |[[SYSPERMS]]||Dynamic roles and permissions | ||
|- | |- | ||
|[[SYSROLES]]||Users and roles | |[[SYSROLES]]||Users and roles | ||
+ | |- | ||
+ | |[[SYSROWFILTERS]]||Role based row level filters | ||
|- | |- | ||
|} | |} |
Latest revision as of 12:44, 2 January 2018
Purpose
System tables containing users, roles and dynamic roles and permissions. They are in the system database.
See Also
System Tables, Users and Roles, Guide to the Users Workspace (Video)
Description
Table | Remarks |
---|---|
SYSDATAMASKS | Role based dynamic data masking |
SYSPERMS | Dynamic roles and permissions |
SYSROLES | Users and roles |
SYSROWFILTERS | Role based row level filters |