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