Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Access denied for user to path /users/uatuser/_prefs/userprefsxmlstore

846947Jan 22 2013 — edited Jan 22 2013
Hi,

I have an 10g RPD and upgraded to 11g RPD(11.1.6) in window.
Now I want to set app roles based on a database table.
So in RPD I create an initialize block to populate and set roles.

select 'ROLES',app_role from roles_auth where upper(uname)=upper(':USER')

and also to check whether it is populating correct data or not, I create another IB Block

select 'JROLES',app_role from roles_auth where upper(uname)=upper(':USER')

While in Analytics I am getting proper values in JROLES, but in MyAccount-->Roles, I am getting only those roles appled in EM not in RPD's IB Block.
And after clicking on the 'OK' button I am getting this error message.

Exception occurred when saving user preferences to the catalog access denied for user to path /users/uatuser/_prefs/userprefsxmlstore.

I have tested this on 2 11.1.5 systems, there it is working fine, so I am missing here.

Thanks,
Sunil
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details