Question

14
Replies
2362
Views
Alex_Pan Member since 2016 13 posts
Capgemini
Posted: 3 years ago
Last activity: 3 years 2 months ago
Closed
Solved

ERROR: permission denied for relation pr_data_admin

Hi,

I've followed recommendations (Pega721_Install_Tomcat_PostgreSQL.pdf) by creating two users for my pega database:

- base user

- admin user

Here are the grants:

grant usage on schema pegadata to pega_appli;

grant usage on schema pegarules to pega_appli;

grant all on all tables in schema pegarules to pega_appli;

grant all on all tables in schema pegadata to pega_appli;

grant execute on all functions in schema pegarules to pega_appli;

grant execute on all functions in schema pegadata to pega_appli;

After the installation, I've started PRPC but I've got errors like:

SEVERE: Unable to connect to database. Will only use properties from file.
org.postgresql.util.PSQLException: ERROR: permission denied for relation pr_data_admin

I've re-executed the grants and it works. Can you tell me if it's the right way to proceed? Thanks

***Updated by Moderator: Marissa to update categories***

Low-Code App Development Installation and Deployment Data Integration SR Created
Moderation Team has archived post
Share this page LinkedIn