Code assistant - missing objects

[bro]

I have select any dictionary privilege, but when typing:

select * from v$sql

I'm getting only 3 objects:
v$sqlfn_arg_metadata
v$sqlfn_metadata
v$sqlpa_metric

Why the rest of them are not visible?
The same is for objects in another schema.
If I have select privileges to other schema objects they are not visible at all in code assistant.
So select * from schema. does not show anything.

Marco, could you explain how objects for code assistant are selected? Can this be fixed somehow?

 

[T-Gergely]

Here's my report about it.
(Ignored since 2016-12-08 16:31)

 

[Marco Kalter]

The objects list for the Code Contents "context description" are taken from the all_objects and all_synonyms views. If you want to include objects from other views, you can modify the CANames.sql file in the PL/SQL Developer installation directory.

 

[bro]

Thanks Marco, it worked

Another question.
Suppose I have schema HR, and I'm logged as user USER1.
In USER1 schema there is HR table.
When I press after select * from HR.
It gives me list of table columns. But I would like to see here list of objects in HR. schema. Is it possible?
I know HR. means something else when used in:
select HR.
and
select * from HR.

 

[bro]

T-Gergely, regarding your post:
It is working for me, at least in 12c.
I mean selecting dba_scheduler* views from all_users.

RAFF@INL_PDB> select username, privilege from user_sys_privs;

USERNAME                       PRIVILEGE
------------------------------ ----------------------------------------
RAFF                           CREATE SESSION
RAFF                           SELECT ANY DICTIONARY

RAFF@INL_PDB> select username, granted_role from user_role_privs;

no rows selected

RAFF@INL_PDB> select owner, object_name, object_type from all_objects where object_name = 'DBA_SCHEDULER_JOBS';

OWNER                          OBJECT_NAME                    OBJECT_TYPE
------------------------------ ------------------------------ ------------------------------
PUBLIC                         DBA_SCHEDULER_JOBS             SYNONYM

RAFF@INL_PDB>

But I also have to make changes in CANames.sql, i.e. add PUBLIC schema na SYNONYM.

Was:

where o.owner = :schema
   and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

Is:

where o.owner in ('PUBLIC', :schema)
   and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE', 'SYNONYM')

 

[T-Gergely]

T-Gergely, regarding your post:
It is working for me, at least in 12c.

Do you mean it's working after changing CANames.sql?

If you want to include objects from other views, you can modify the CANames.sql file in the PL/SQL Developer installation directory.

See #54944 and #54946 in my closed topic. These were not answered. It's a regression.