Diagnosing Issues with Oracle Roles, BANSECR.GURUSRI, and SSO Proxies

BANSECR.GURUSRI

Proxy Assignments

2) Secondly, even though these roles relate primarily to Banner INB access, I make sure that an entry has been made into the GURSRI table and the user has been granted both proxies necessary for SSO. This user did have an entry in BANSECR.GURUSRI, but did not have either proxy in PROD, even though the user had been granted CORE_BANNER_PROD_CLS which should provide that proxy.

ZUAUSR@prod> select proxy from proxy_users

2 where client = 'SXARS';

no rows selected

I added them:

ZUAUSR@prod> alter user sxar20 grant connect through banjsproxy;

User altered.

ZUAUSR@prod> alter user sxar20 grant connect through banproxy;

User altered.