Question

14
Replies
2452
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 Support Case Created
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.