Sureh Please check to make sure the database owner is same as the owner of the table.
On Tue, Mar 26, 2013 at 1:34 PM, Thiagarajan, Suresh wrote:
I am using version 3.1.1 community on CentOS, with postgres 8.4. I get the following exception while trying to view the Notes & Discrepancies tab (nothing on the client side):
org.postgresql.util.PSQLException: ERROR: permission denied for relation discrepancy_note
Howerver, I don't get this exception on another system which runs the same version of OpenClinica and postgres. The only difference is that the database users are different. I don't know how to reproduce this error on a different machine. I tried changing the ownership of the table on an instance that is working correctly to something other than 'clinica' and 'postgres' (these were the users on the two instances that are not showing this exception), but that did not reproduce the issue.
I have attached the log file for convenience. What is the issue here?
Email Disclaimer: www.stjude.org/emaildisclaimer
Consultation Disclaimer: www.stjude.org/consultationdisclaimer