| Schema Broswer [message #550920] |
Fri, 13 April 2012 09:09  |
pointers
Messages: 451
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 #550926 is a reply to message #550920] |
Fri, 13 April 2012 09:30  |
pointers
Messages: 451
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 #551019 is a reply to message #550920] |
Sat, 14 April 2012 17:50 |
pointers
Messages: 451
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 #551082 is a reply to message #551044] |
Sun, 15 April 2012 09:50 |
pointers
Messages: 451
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 |
 |
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
pointers
Messages: 451
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
