Access denied for user to path /users/uatuser/_prefs/userprefsxmlstore
846947Jan 22 2013 — edited Jan 22 2013Hi,
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