I am trying to set up connect through a proxy user and only permit the activation of specific roles. I have the following:
ALTER USER "Jane.-.Doe" GRANT CONNECT THROUGH XXX_PROXY WITH ROLE XXX_ROLE, SAR_XXX_ROLE;
The problem, I suspect, is that SAR_XXX_ROLE is a secure application role because I'm getting this error:
ORA-28168: attempted to grant password-protected role
I can't find any documentation to prove or disprove what I am finding through testing. The documentation about using WITH ROLE is brief and generic and doesn't go into any detail about usage with different types of roles.
Can anyone tell me if they have successfully used the WITH ROLE clause of the proxy_clause with a secure application role?
Any input is greatly appreciated (documentation links or examples). Thanks!
ALTER USER "Jane.-.Doe" GRANT CONNECT THROUGH XXX_PROXY WITH ROLE XXX_ROLE, SAR_XXX_ROLE;
The problem, I suspect, is that SAR_XXX_ROLE is a secure application role because I'm getting this error:
ORA-28168: attempted to grant password-protected role
I can't find any documentation to prove or disprove what I am finding through testing. The documentation about using WITH ROLE is brief and generic and doesn't go into any detail about usage with different types of roles.
Can anyone tell me if they have successfully used the WITH ROLE clause of the proxy_clause with a secure application role?
Any input is greatly appreciated (documentation links or examples). Thanks!
