An internal table used to provide optimized performance for RLS and queries against users/groups/addresses.
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_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 with the groups to apply security against. |
|
INTEGER |
|
For SQL Server databases only. |
|
|
EffectiveStartDate Date the user joined this group. |
|
TIMESTAMP |
8 |
None |
|
|
EndDate Date the user was removed from the group |
|
TIMESTAMP |
8 |
|
|
|
AddressUID1 Part-key identifying the users address associated with the entry. |
|
INTEGER |
4 |
Can be NULL |
|
|
AddressUID2 Part-key identifying the users address associated with the entry. |
|
INTEGER |
4 |
Can be NULL |
|
|
UserIDM Part-key identifying the user associated with the entry. |
|
INTEGER |
4 |
|
|
|
UserID Part-key identifying the user associated with the entry. |
|
INTEGER |
4 |
|
|
|
GroupIDM Part-key identifying the user's group associated with the entry |
|
INTEGER |
4 |
|
|
|
GroupID Part-key identifying the user's group associated with the entry |
|
INTEGER |
4 |
|
|
|
Copyright © 2014 CA.
All rights reserved.
|
|