Hi all,
I'm looking for options to find out the way to identify users who are having particular privileges. For instance, i want to find out all users who are having "Create procedure|Create any procedure" procedure. I have tried with "DBA_ROLE_PRIVS" and mapped with "ROLE_SYS_PRIVS" but later one return user specific information. Since i want the information at database level this view is not much helpful.