I have used following link as reference to deploy PostgreSQL in local instance:
As mentioned in the link, I have created 2 user roles- sysadmin and public user profile(to set up connection to the restored db). whenever I use public user login in connection config file, I get an error: "42501:permission denied for table SysSettings".
However sysadmin credentials seem to work. Kindly help in resolving the issue.
Like
Dear Gokul,
Thank you for your question!
Please be advised that this issue has been resolved within the support ticket submitted to us.
As discussed in the ticket, we recommend using the following link to deploy the PostgreSQL in the local instance:
https://academy.creatio.com/documents/administration/7-16/postgresql-da…
We appreciate your cooperation!
Thank you!
Regards,
Danyil
Danyil Onoprienko,
Thank you for providing solution. I was able to resolve the error.