[reporter="ksecretan", created="Tue, 1 Mar 2011 21:02:02 -0800"]
So if we create a user u1, if that user tries to log in they will get a big fat empty list under the Schemas menu. This may be the case, but what happens if they have a certain schema? It will still not show it! This is because the web services uses dba_schemas in its query returning the list of schemas (I think), which isn't allowed under u1's connection privs.
Is there a way for user u1 to figure out what they have permission to access? (Need to see which views are available if any.)
[reporter="ksecretan", created="Tue, 1 Mar 2011 21:02:02 -0800"]
So if we create a user u1, if that user tries to log in they will get a big fat empty list under the Schemas menu. This may be the case, but what happens if they have a certain schema? It will still not show it! This is because the web services uses dba_schemas in its query returning the list of schemas (I think), which isn't allowed under u1's connection privs.
Is there a way for user u1 to figure out what they have permission to access? (Need to see which views are available if any.)