Proxy Users vs Roles
I'm new to Oracle DB and wondering why you would use a proxy user rather than a role? For example, I have a DB DBUserA that has a certain set of privileges. I have X other people that require an account with the same priviledge but I don't want them to have the password for DBUserA. Why would I not just create a role with all the privileges of DBUserA and then assign this role to 5 new DB users and give them out to the team as opposed to creating these new users a proxies to the DBUserA user? The only thing I can think of is that in some estates this is difficult to do and maintain due to roles/best practive not being
0