PeterG0262 Member since 2019 6 posts
Posted: April 16, 2020
Last activity: April 20, 2020

Query inspector for Delete gives permission denied PSQLException

On our pegacloud 8.3.x environment I have been experimenting with different indexes to optimize slow queries in the database and the tool Configure > System > Database > Query inspector has been very helpful.  

In this case however I am trying to optimize a delete statement.

DELETE FROM pegadata.myorg_idx_myclass_Myembeddedpage WHERE pxInsIndexedKey = 'foo' AND pxIndexPurpose = 'InterestingPropertyCatIdx'


Since this is just ending up doing an explain, shouldn't it be allowed, as no modification to the database occurs?

Instead I get error

There was a problem getting a list: code: 0 SQLState: 42501 Message: ERROR: permission denied for table myorg_idx_myclass_Myembeddedpage DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: permission denied for table myorg_idx_myclass_Myembeddedpage  | SQL Code: 0 | SQL State: 42501

Can postgresql be configured to allow these explains, but still prevent write access?


Pega Platform 8.3 System Administration Financial Services Senior System Architect
Share this page LinkedIn