I have to create an Oracle user to enable access from an application that would then access and scan the metadata from the Oracle Database. Are read-only permissions sufficient to be able to retrieve metadata information from the Oracle database. Can anybody please help me what specific / minimal user permissions / privileges are needed for the user credentials to be able to only retrieve the metadata information like (Table Names, View Names their properties and definitions).
I have provided the following privileges, however when I connect through SQL Developer using the user credentials i don't see the list of tables & views. Am I missing something here ?
PRIVILEGES:
CREATE SESSION
Select ANY DICTIONARY
Select ANY TABLE
Select ANY SEQUENCE
Can anyone please help on this