For Vantage systems configured with secure zones, data dictionary access is constrained by zone.
The data dictionary contains zone specific system views ending in _SZ for related Unicode and compatibility views. Zone specific views are not needed for VX views because they already contain security constraints in their definition that limit the result set to only the rows associated with the requesting user.
Even with Teradata Secure Zones configured, all users query the non _SZ views. Privileges are checked against the non _SZ view.
The following table shows data dictionary view access for the users.
User | Data Dictionary View Access |
---|---|
|
These users get system-wide information from views without zone filtration. For example, if DBC or a non-zone user with ZONE OVERRIDE does a SELECT from the QryLogXMLV view, they will get information from the QryLogXMLV view without any filtration by zone. |
|
Access is constrained by zone. For example, if a zone user does a SELECT from the QryLogXMLV view, information is returned from the zone constrained view. |
|
These users are restricted to non-zone dictionary data only. |
The following views are constrained by zone.
|
|
|
To see the secure zones views in the data dictionary, the Secure Zones feature must be enabled first. Contact your Teradata representative to enable this feature.