An internal table that is dynamically populated at runtime to provide security context for searches. 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_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 with the groups to apply security against. |
Yes |
INTEGER |
|
For SQL Server databases only. |
|
GroupIDM Part-key identifying the group that the user belongs to. |
Yes |
INTEGER |
4 |
|
|
GroupID Part-key identifying the group that the user belongs to. |
Yes |
INTEGER |
4 |
|
|
ParentGroupIDM Part-key identifying the parent group that the user belongs to. |
|
INTEGER |
4 |
|
|
ParentGroupID Part-key identifying the parent group that the user belongs to. |
|
INTEGER |
4 |
|
|
Copyright © 2014 CA.
All rights reserved.
|
|