This discussion is archived
2 Replies Latest reply: Mar 1, 2013 7:01 AM by Jeff Smith SQLDev PM RSS

Importing data into tables with grant access (sql developer 3.2)

igwe Newbie
Currently Being Moderated
I want to import data into a table PAY_BALANCE_BATCH_LINES which is an interface table. I'm logged in to a schema (APPS) and this table belongs to the HR schema. However, if you look at the grants, the APPS schema has all access to this particular table. In TOAD, this used to work great.
But in sqldeveloper, when I filter the tables dropdown, I am not able to find this table. Since this is my primary way of uploading data I'm not sure how else I can get access to upload data into this table. I don't know the password for the HR schema by the way.
Is there a way out?
Many Thanks


  • Correct Answers - 10 points
  • Helpful Answers - 5 points