Home » SQL & PL/SQL » Client Tools » Schema Broswer (Toad 9.7.2.5)
Schema Broswer [message #550920] Fri, 13 April 2012 09:09 Go to next message
pointers
Messages: 439
Registered: May 2008
Senior Member
Hi,

I am using Toad for Oracle and version is 9.7.2.5

The question is when access schema browser to access objects of the another schema, it displays the object name, but when I click on the data option to display data it shows that table or view does not exists.

I know the reason, because of the privileges, the objects are not accessible to the logged in user of other schema, but only question is how/why Toad shows the objects in the schema browser if it is not accessible. Is there any metadata tables to know the theroy behind.

Regards,
Pointers.
Re: Schema Broswer [message #550923 is a reply to message #550920] Fri, 13 April 2012 09:13 Go to previous messageGo to next message
BlackSwan
Messages: 25849
Registered: January 2009
Location: SoCal
Senior Member
http://toadfororacle.com/
Re: Schema Broswer [message #550924 is a reply to message #550923] Fri, 13 April 2012 09:18 Go to previous messageGo to next message
cookiemonster
Messages: 13011
Registered: September 2008
Location: Rainy Manchester
Senior Member
Has you user got select privs on some of the dba views?
Like dba_tables, dba_objects?
Re: Schema Broswer [message #550926 is a reply to message #550920] Fri, 13 April 2012 09:30 Go to previous messageGo to next message
pointers
Messages: 439
Registered: May 2008
Senior Member
@Cookiemonster: Thank you very much for your post, Yes my schema do have access to the dba views like dba_tables, dba_objects.

Could you please explain does it cause to display objects of other schema in schema browser but not data of the objects.

Thank you very much in advance.

Regards,
Pointers.
Re: Schema Broswer [message #550930 is a reply to message #550926] Fri, 13 April 2012 11:03 Go to previous messageGo to next message
Michel Cadot
Messages: 65380
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because you have not SELECT ANY TABLE.

First try to do it in SQL*Plus and when it works try to do it in TOAD.

Regards
Michel
Re: Schema Broswer [message #551019 is a reply to message #550920] Sat, 14 April 2012 17:50 Go to previous messageGo to next message
pointers
Messages: 439
Registered: May 2008
Senior Member
@Micheal: Yes, I dint have the role, those objects were not accessible from sqlplus, but my only confusion for that matter what is the theory showing the inaccessible objects in the schema browser.

Regards,
Pointers
Re: Schema Broswer [message #551044 is a reply to message #551019] Sun, 15 April 2012 01:20 Go to previous messageGo to next message
Michel Cadot
Messages: 65380
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have the right to know the name of the objects but not the right to see inside them.
Just like cleaning lady is able to see you have a safe but can't see what's inside it.

Regards
Michel
Re: Schema Broswer [message #551082 is a reply to message #551044] Sun, 15 April 2012 09:50 Go to previous messageGo to next message
pointers
Messages: 439
Registered: May 2008
Senior Member
@Michela: Yes, I do understand your words. But as for as I know, I dont think any such Oracle Role which would allow to see the objects but not object, do you think it is Toad specific role kind of or any oracle role as such. Could you please share if such an role exists.

It may not be necessary to know all these, but I had to enlighten couple of my project mates on this theory who does not understand how it works.

Regards,
Pointers
Re: Schema Broswer [message #551091 is a reply to message #551082] Sun, 15 April 2012 10:42 Go to previous messageGo to next message
Michel Cadot
Messages: 65380
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I dont think any such Oracle Role which would allow to see the objects but not object,

SELECT_CATALOG_ROLE role gives you the right to see the objects through DBA% views
SELECT ANY TABLE privilege gives you the right to see inside any table/view (but SYS ones).

Regards
Michel

[Updated on: Sun, 15 April 2012 10:42]

Report message to a moderator

Re: Schema Broswer [message #551093 is a reply to message #551091] Sun, 15 April 2012 10:56 Go to previous message
pointers
Messages: 439
Registered: May 2008
Senior Member
Thank you very much Micheal

So, Toad may show the objects through the DBA_% views as i do have access to such views, but as i dont have 'select any table' privilege, i am getting the 'lack of privileges error', which sounds quite reasonable to tell my colleagues why toad schema browser displays the objects on which we don't have access.

Again, thanks a lot Micheal.

Regards,
Pointers
Previous Topic: Unable to open file
Next Topic: problem related to database mount
Goto Forum:
  


Current Time: Sun Feb 18 21:49:59 CST 2018

Total time taken to generate the page: 0.06679 seconds