Question

3
Replies
48
Views
Close popover
Peter Gousios (PeterG0262)
USAA

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

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
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.