HOW TO GRANT THE SELECT PRIVILEGE ON A VIEW TO THIRD PARTY USERS
Granting SELECT privilege on a view to other users when underlying objects of such a view do not belong to the owner of the view.
USER WITH "SELECT ANY TABLE" PRIVILEGE GETS "ORA-00942: TABLE OR VIEW DOES NOT EXIST"
A user with SELECT ANY TABLE privilege gets ORA-00942: TABLE OR VIEW DOES NOT EXIST when quering any table.
HOW TO FIND ALL OBJECTS PRIVILEGES GRANTED TO A USER IN AN ORACLE DATABASE
Here is a query to a data dictionary table for finding out all the object privileges that a particular user or a role has. It also displays if a privilege is transferred directly or through a role.
HOW TO FIND SYSTEM, ROLES AND OBJECTS PRIVILEGES THAT HAVE BEEN GRANTED TO A USER
How to find the privileges that have been granted to a user by querying data dictionary views.
HOW TO RETRIEVE AN OBJECT DDL OR A USER DDL USING PL/SQL
How to extract metadata of users, tables, views, triggers, and other Oracle database objects by using the metadata API.