There are two ways to do it.
1) Login as a user which have ORADBA privilege and connect to the database using / as sysdba
2) I you are not querying the fixed tables (X$ tables) then create a user grant him only the read privileges on the tables you want to query (ex: select_catalog_role) and use it for your purpose.




Reply With Quote