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 © 2014 CA.
All rights reserved.
|
|