Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1948
  • Last Modified:

Oracle User Cannot See tables or select

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?

  • 2
  • 2
1 Solution
Walk me through some of the steps.. You created an user and provided all the privileges.. Now you are trying to view objects.. What command are you using in SQL Plus? Try executing the below queries

select * from dba_objects;

select * from dba_objects where owner='UPGRADE';

First query would return all the objects in the DB. Second query will return only the objects owned by UPGRADE
mattturleyAuthor Commented:
I created the user in Enterprise Manager, granted all privileges.  If I try to query the db, for example:

select * from pa_student;

I get ORA-00942: table or view does not exist.

I can easily browse to the table and view data when logged into EM as this user.

Your first query pulled back thousands of rows - I stopped it.

The second pulls back zero rows.

Ok.. This means the user UPGRADE does not own any object.. When you are accessing other users objects, you should access like this..

select * from <username>.table;

If you see EM, it would be displaying the tablename in the same way. Owner.objectname
mattturleyAuthor Commented:
It isn't indicating that way in EM - just has the table name.It doesn't show that way in EM, but when I query that way in SQL Plus, I get no rows returned, instead of table or view does not exist.
When you navigate in EM you choose "schema" -> "schema name" -> "tables" -> "your table" right?

Schema is the owner, the name of the owner.

Like ravindran_eee wrote..
select * from <username>.table; = select * from <schema_name/owner>.table;

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now