|
|
|
An internal table used to provide optimized performance for RLS models that are required to exclude the user (currently the logged on user). This table contains the UserID/IDM and associated addressUID1/2 of the user that is to be excluded from RLS search results.
Note on SQL Server this table is a normal table and contains the column SPID (as shown below) on Oracle it is implemented as a Global Temp Table and does not have column SPID.
This table should never be accessed directly, only via the view WGN_V_RLS_EX_ADDR_1, which has a consistent interface for both SQL Server and Oracle.
On Oracle CBO stats should never be manually collected for this table as the contents are volatile, optimizer dynamic sampling (level 3) should be used.
|
Column |
Primary Key |
Datatype |
Length |
Notes |
|
|---|---|---|---|---|---|
|
SPID This identifies the DBMS connection associated user to exclude. |
|
INTEGER |
|
For SQL Server databases only. |
|
|
AddressUID1 Part-key identifying the users address associated with the excluded user. |
|
INTEGER |
4 |
|
|
|
AddressUID2 Part-key identifying the users address associated with the excluded user. |
|
INTEGER |
4 |
|
|
|
UserIDM Part-key identifying excluded user. |
|
INTEGER |
4 |
|
|
|
UserID Part-key identifying the excluded user. |
|
INTEGER |
4 |
|
|
An internal table that is dynamically populated at runtime to provide security context for searches. This table is populated if the logged on user is subject to a Policy based security model, and in which case it contains all the policy ids that user is permitted to access.
Note on SQL Server this table is a normal table and contains the column SPID (as shown below) on Oracle it is implemented as a Global Temp Table and does not have column SPID.
This table should never be accessed directly, only via the view WGN_V_RLS_POLICY_1 , which has a consistent interface for both SQL Server and Oracle.
On Oracle CBO stats should never be manually collected for this table as the contents are volatile, optimizer dynamic sampling (level 4) should be used.
|
Column |
Primary Key |
Datatype |
Length |
Notes |
|
SPID This identifies the DBMS connection associated with the groups to apply security against. |
Yes |
INTEGER |
|
For SQL Server databases only. |
|
PolicyID Key identifying the Policy class that the user can access |
Yes |
INTEGER |
4 |
|
|
PolicyName Name of the Policy class that the user can access |
|
VARCHAR |
255 |
|
|
ParentPolicyID Id of the parent Policy class |
|
INTEGER |
4 |
|
|
ParentPolicyName Name of the parent Policy class |
|
VARCHAR |
255 |
|
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |