Is there a place in SQL Developer that contains roles?
Most systems that I have worked with operate on a user, role, permission model. Typically, In Oracle, that would be users, roles and privileges. In my experience, roles rate their own folder.
Now, without any intentions of disparaging Oracle, it does not seem to have a counterpart to what I am used to seeing. You can get a list of roles using SQL commands, but I was hoping to be able to “explore” the available roles without having to open a user and editing them to scroll through the Granted Roles tab or writing a query every time. This seems very indirect.
Hopefully it's just me and there is a way that I am not familiar with.
Rob