O7_DICTIONARY_ACCESSIBILITY

[BushPilot]

Hi...
I am on PL/SQL Developer ver 6.0...
Database is now on 9i

The auditors requirements are that ..
O7_DICTIONARY_ACCESSIBILITY be set to FALSE.

The result is that I can not expand the items under the browser window. ie "procedures " etc.

How do I overcome this?

Regards

 

[Marco Kalter]

What exactly goes wrong?

 

[BushPilot]

When I try to expand any object in the browser ie. procedures, tables ... I get an Oracle error..
ora-942 table or view does not exist...
In the past we had the grant "Select any Table", but now I understand from the DBA that they need to grant select to each v_*..... table.

Hope this can add some light.

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debug parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debug

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.