Oracle User Cannot See tables or select
Posted on 2009-02-09
I am having problems with a user not being able to see tables, select data, or do anything other than logging in. I granted the user all priveleges using
grant all privileges to UPGRADE
If I login to Enterprise Manager with that user, I can see all objects in the database of concern (DOLPLAT). However, if I connect via SQLDeveloper or SQL Plus, I can only login. I cannot select data or in any other way work with the database - outside of logging in.
I am sure this could be one of many things. Can you suggest some troubleshooting steps/tips I might look towards?