Timeline for ORACLE SQL DEVELOPER can't see all View
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 10, 2013 at 18:12 | vote | accept | ricardo | ||
| Oct 10, 2013 at 15:01 | comment | added | Sean Dulin | I'm assuming you're in PL/SQL Developer by All-Around Automation. You should have an Object Browser on the left or right side of the screen. There should be a drop down near the top that has schema's in it. Try changing that to the schema the view is in. Then expand the views folder. | |
| Oct 10, 2013 at 13:56 | comment | added | ricardo | If I do a SELECT * FROM SOME_USER_VIEW_NAME. I got the results in the SQL Developer. But this SOME_USER_VIEW_NAME does not shows in objects browser. And I only have this user and I can't ask the DBA more permission.... | |
| Oct 10, 2013 at 12:35 | comment | added | Sean Dulin | I don't know of a way for you to see if the view exists, but not be able to select it. You should just need to grant reads to the objects you want to see. grant select on {schema.viewname} to {user}. Alternatively, you can create a role, grant read on all objects in that schema you want to see to that role. Grant your user that role. grant {role} to {user}. | |
| Oct 10, 2013 at 12:21 | comment | added | ricardo | Do you know if there are a way to a limited user see the schema it have only read access? | |
| Oct 10, 2013 at 0:51 | history | answered | Sean Dulin | CC BY-SA 3.0 |