Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center