Object Browser Folders: Objects are being rejected

[kirilb]

Within an user defined folder when I try to put an object (existing table in my case) like described in the documentation e.g. "SCOTT.EMP", it is being discarded and not stored. Why?

 

[Marco Kalter]

This seems to be a documentation error. The correct syntax is:

TYPE OWNER.NAME

In this case:

TABLE SCOTT.EMP

 

[kirilb]

great, this is it. Thanks!

 

[kirilb]

However next problem is that the new folder is not visible for other users. I have tried with all variations in the settings:
- Checkbox "visible"
- Supress owner
- Connection

 

[Marco Kalter]

What exactly do you mean by "other users"? Other Windows users or other Oracle users?

 

[kirilb]

other Oracle users (and Oracle users are Windows users anyway, since we all here are with windows, but not the other way around)

 

[Marco Kalter]

Perhaps these Oracle users do not have any privileges on these objects?

 

[kirilb]

all those users are part of same role and this role has read privileges on this tables

 

[Marco Kalter]

This works fine for me. Can you check the following?

• Do you see the objects if you connect as SYS to this database?
• Do all users have select privileges on the SYS.DBA_OBJECTS view?
• Is the "Use DBA views if available" option enabled? (Preferences > Oracle / Options)

 

[kirilb]

Pls find my answers inline after each line:

Do you see the objects if you connect as SYS to this database?

 

[kirilb]

P.S. If you mean "connect as SYS to this database" connect as DBA, then no, I dont have admin privileges

 

[Marco Kalter]

Okay. Can you connect as one of the users where these objects are missing and execute the following query in a SQL Window?

select * from all_objects
where object_type = '<TYPE>'
and owner = '<OWNER>'
and object_name = '<NAME>';

For example:

select * from all_objects
where object_type = 'TABLE'
and owner = 'SCOTT'
and object_name = 'EMP';

Try the same for dba_objects instead of all_objects.

Let me know how this turns out.

 

[kirilb]

I can execute both queries and get data about the object name I searched for.
But this might be interesting for you: I am not the owner of the tables I want to put into own folder, however I am allowed to put a role with read privileges to this table.

 

[Marco Kalter]

If the object is returned for the all_objects query, then it should be displayed in the folder.

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

"C:\Program Files\PLSQL Developer 12\plsqldev.exe" DebugSQL

Reproduce the problem (open the folder with these objects) and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 12 directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer 12).

 

[kirilb]

Hi Marco, did you see my email (from 21.02) to 'support@allroundautomations.com' with the debug data?

 

[Marco Kalter]

I don't think so. Can you resend it?

 

[Marco Kalter]

We have received it now, thanks. It seems that all objects are fetched successfully. It is not immediately obvious why the objects are not displayed. We'll have to investigate what the reason might be.

 

[kirilb]

great, thanks!