Home » SQL & PL/SQL » SQL & PL/SQL » How know the tables on which I have select access (Oracle 10g - SQL)
How know the tables on which I have select access [message #387063] Tue, 17 February 2009 16:13 Go to next message
sangram_ocp
Messages: 12
Registered: February 2009
Location: Mumbai
Junior Member
When I am firing the below query I am getting result.

select owner,count(table_name) from all_tables group by owner;

i.e table counts for each user.

I have four schemas in my application.
I can see the table names from all_tables where owner='XYZ'

XYZ means my application schema name.

But when I am trying to select data from those tables:
for some tables I can select the data and for some tables it says

Table or view doesn't exist.

I am surprised.

Is there any flag column which decides the access?

~Sangram

[Updated on: Tue, 17 February 2009 16:14]

Report message to a moderator

Re: How know the tables on which I have select access [message #387064 is a reply to message #387063] Tue, 17 February 2009 16:18 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
Show us what statements generate the error (copy and paste a sql session that generates the error that you talk about)
Re: How know the tables on which I have select access [message #387067 is a reply to message #387063] Tue, 17 February 2009 16:56 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>I am surprised.
I am not surprised.

>Is there any flag column which decides the access?
no, no "flag" column per se; but possibly the OWNER column.

You would benefit from Reading The Fine Manual
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.
Re: How know the tables on which I have select access [message #387102 is a reply to message #387067] Tue, 17 February 2009 22:40 Go to previous message
trivendra
Messages: 208
Registered: October 2007
Location: Noida, India
Senior Member
Are you logged as XYZ in your database?

If you are looged as other user there can be problem with

1. Privileges
2. If privileges are there, <user_name>.<table_name> must me be missing

And privileges can be seen in USER_TAB_PRIVS/ALL_TAB_PRIVS.

Thanks
Trivendra


[Updated on: Tue, 17 February 2009 22:55]

Report message to a moderator

Previous Topic: Automatic Value Passing to WHERE Clause...
Next Topic: Oracle 10g, Win XP
Goto Forum:
  


Current Time: Thu Dec 08 08:16:06 CST 2016

Total time taken to generate the page: 0.08138 seconds