2 Replies Latest reply on Jun 17, 2015 1:21 PM by 2873d34b-71b9-4365-a3bf-5314ea44d0a6

    What Permissions are needed for the user to have read only access to metadata - using SQL Developer

    2873d34b-71b9-4365-a3bf-5314ea44d0a6

      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