Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

4
  • Do you know if there are a way to a limited user see the schema it have only read access? Commented Oct 10, 2013 at 12:21
  • 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}. Commented Oct 10, 2013 at 12:35
  • 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.... Commented Oct 10, 2013 at 13:56
  • 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. Commented Oct 10, 2013 at 15:01