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:
- 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?
- ALTER USER phx_prod grant CONNECT THROUGH DMILLER;