User with "DBA" Role and "Select Any Dictionary" privileges get ORA-00942 when selecting X$ tables
(Doc ID 2865776.1)
Last updated on MAY 02, 2022
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
A user with "DBA" role and "select any dictionary" privilege cannot access X$ tables. They will have an ORA-00942: Table or View does not exist error returned.
Some application users need to access and read Oracle X$ tables
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document