- Objects owned or created by the user
- Objects on which the user has been granted privileges
The following Unicode X views and compatibility X views also return rows associated with the current role of the user and any nested roles of that current role.
- If the role has privilege on all in TVMs
- If the role has privilege on this specific TVM
It also depends on the current session role of the user to determine what roles are used to verify privileges.
|If the current role is. . .||Then . . .|
|not NULL or ALL||the current role and its nested role are used for security checks.|
|ALL||all the role(s) directly granted to the user and all their nested role(s) are used for security checks.|
X views run slower than their corresponding non-X versions because the X views have security checks.
Compatibility X views are named the same as their corresponding non-X views followed by the character X.
Unicode X views are named the same as their corresponding non-X views followed by the character V.