Question

8
Replies
517
Views
NagarajP0101 Member since 2017 54 posts
ING Belgium SA NV
Posted: 2 years ago
Last activity: 2 years 3 months ago
Closed

Pega Marketing Upgrade - error while running Marketing setup utility

We are upgrading pega marketing to 7.3.1 version and its mentioned in db_specif file that privileges must be granted to deploy and data user.

GRANT CREATE TABLE TO Datauser;
GRANT CREATE ANY TABLE TO DEPLOY_USER;
GRANT CREATE ANY MATERIALIZED VIEW TO DEPLOY_USER ;

But , create table and create any materialized view privilege is already been added to the user/schema.
Error :[sql] java.sql.SQLSyntaxErrorException: ORA-01031: Onvoldoende rechten

Kindly advise what is missing here? should privileges be provided with "with admin option"?

Decision Management Low-Code App Development Installation and Deployment Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn