Recent content by BushPilot

What other V$ views/tables is used in the product? We need to restrict/ revoke select any table from all users/devellopers. This now results in an ora-942 when they expand the browser.

What do I do in our environment....??? Being a BANK...the Auditors do not allow datbaselink between DEV and TEST and PRODUCTION..... ??????????

PL/SQL Developer uses one connection to connect and offer all the items in the browser etc. If you create a new SQL session/window in PL/SQL Developer, it does another database connection. So if you open 4 new SQL session, you will have 5 database connections under that user. There is definitly...

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...

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