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!