schemacrawler not returning all Oracle tables - what permissions are required? -
using schemacrawler , trying connect oracle database. resulting json file including 10 tables, expecting larger number of tables in database.
this must restricted permissions of user being used access oracle database, permissions required user schemacrawler able "see" table/columns?
presumably schemacrawler uses data dictionary. user restricted tables , columns visible in all_tab_cols view i.e. tables have @ least select privilege on.
otherwise user needs select on dba_tab_cols, shows tables in schemas. requires dba access grant.
Comments
Post a Comment