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?