Code Assistant Problems

[Todd M]

We have several developers who are having issues seeing the full list of views from the dba_* dictionary with code assistant. They have been granted the 'SELECT ANY DICTIONARY' privilege and it is reflected in querying dba_sys_privs.

Only 21 objects show up in the code assistant list after they type dba_ , but they are able to successfully query from all of the dba_* views. I have had one of them delete the CodeAssistantHeight registery key suggested in a different post and then restart, but that made no difference.

They do have "Use DBA Views if Available" selected, and everything in Code Assistant is checked. We are all using Version 11.0.6.1776 64-bit with this group using an Oracle 11.2.0.4.x database.

 

[Marco Kalter]

When typing "dba_" the Code Assistant will show matching names from an object list that is generated through the queries specified in the CANames.sql file in the PL/SQL Developer installation directory. Perhaps you can check if these queries do indeed only produce 21 object names starting with "dba_"? Maybe this will provide a clue.

Note that you can modify the CANames.sql file to control the Code Assistant object list.

 

[Todd M]

Thank you. It appears that using the "SELECT ANY DICTIONARY" privilege doesn't work with the queries, but when we revert to granting "SELECT_CATALOG_ROLE" our users are able to return the full list.