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


      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 ?





      Select ANY TABLE

      Select ANY SEQUENCE


      Can anyone please help on this