Question

14
Replies
2417
Views
Close popover
Alex Pandourangam (Alex_Pan)
Capgemini
Application Officer
Capgemini
FR
Alex_Pan Member since 2016 13 posts
Capgemini
Posted: December 13, 2016
Last activity: August 1, 2017
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***

System Administration Installation and Deployment Data Integration SR Created
Moderation Team has archived post