Database Administration (MOSC)

MOSC Banner

Proxy users - flags = PROXY MAY ACTIVATE ROLE/PROXY MAY ACTIVATE ALL CLIENT ROLES

in 12.2 RAC database. We have been using proxy for a long time.

To give proxy to a user, we have always run the following syntax:

  1. ALTER USER phx_prod GRANT CONNECT THROUGH ksmith;

the result will show:

Today I ran this and the flags shows "PROXY MAY ACTIVATE ALL CLIENT ROLES". I cannot figure why these flags are different although, I ran the same sql?

  1. ALTER USER phx_prod grant CONNECT THROUGH DMILLER;


Tagged:

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