Recent content by HSchuerger

Please let us know if there is anything we can do (configuration-wise) to allow right-click describe with the security we have in place. If not, please explain what is required. I think direct-grants are a bad idea. Role-based grants should suffice.

Greetings. I was wondering if there were any observations to report based on the debug files provided.

An account with the DBA role cannot make effective use of right-click-describe as Describe is not an option. F4 also does not work. Must search or otherwise navigate to the object first. http://www.facstaff.bucknell.edu/hs029/STUFF/Debug-set-role-DBA.txt

The following files represent two testing sessions. The difference between the two is modest. Both sessions have access to DBA views. The second session enabled a password-protected role that also has SELECT on tables and EXECUTE on packages involved in a development project. Links to the...

I will create a debug trace. Meanwhile, is there a limitation on F2 and F4 functionality when object privilege is via a role?

We do have that option enabled. Package logic is not available because it uses ALL_PROBE_OBJECTS as the basis for making it available. It seems there should be an alternative for that. I have yet to determine why the right-click Describe option is not available for tables/views in the SQL...

Is there a definitive answer to this security question?

declare c integer := 0; p1 varchar2(500); p2 varchar2(500); expr varchar2(500); dblink varchar2(500); part1_type integer...

We are on Oracle 11gR2. We have version 10.0.5.1710 installed. We have SELECT on DBA views granted via a role. We have Tools, Pereferences, Oracle, Options, "Use DBA Views if available" selected. Right-click on a table-name does not include Describe as an option. I had this security configured...