Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer 23.1.1.345

user545194Jun 16 2025 — edited Jun 16 2025

1 Issue and 2 questions.

Issue: Editing a user: When removing a role as default in the GUI we noticed that the role was still marked as default after reopening the GUI.

Question 1: Is it possible to disable the “Find Database Object Window”? This would make the role useless, if there is sensitive data in the database, that is protected by a role.

Question 2: We are using a startup script that sets 2 roles:

SET role SELECT_CATALOG_ROLE;
SET role ANOTHER_ROLE;

When querying select * from session_roles; we see that only ANOTHER_ROLE is set, regardless if one is default or not. Is this the expected behavior?

Thanks!

Comments
Post Details
Added on Jun 16 2025
5 comments
147 views