Question
Pega Marketing Privilege issue while running pega market setup utility
while upgrading pega marketing framework to version 7.22, we are getting following privilege issue
ORA-12083,ORA-01031,ORA-12006 . PFA, run sql errors file and privileges that deploy user is having.
Kindly help me in fixing this issue.
Hi Nagaraj,
Could you please check if the proper privilege has been given to your externalMKT user.
Please refer the below guide to perform upgrade to Pega marketing 7.22:
https://docs-previous.pega.com/pega-marketing-722-upgrade-guide
Regards,
Vikash
As mentioned by document,Pega marketing user(externalMKT user) is having below expected privileges,
"Pega Marketing schema :This schema must have the database privileges to create views and to select from tables in the
PegaDATA schema"
It has create Materialized view and select any tables privileges. but still, this issue occurs.
Please advise if above mentioned privileges are the expected or i am missing something here?