Postgres as a Service

Lawrence, Sharon 1

What permission is need to kill a query process in postgres as a service?

1 answer

GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee

2022-01-28T19:12:23.413+00:00

Hi, @Lawrence, Sharon Welcome to Microsoft Q&A, Thanks for posting your query.

You need to be a query owner or a db admin.

Regards
Geetha
Please sign in to rate this answer.
Oury Ba-MSFT 16,081 Reputation points Microsoft Employee

2022-01-28T20:39:42.96+00:00

@Lawrence, Sharon Please do not forget to mark as accepted answer if the reply above was helpful.

Regards,
Oury

Lawrence, Sharon 1 Reputation point

2022-01-31T04:48:55.487+00:00

I am a db admin, however, I could not kill the process from pgadmin tool. What level of permission do I need at the Azure level. The tool said I had to be a superuser.

GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee

2022-01-31T16:13:01.487+00:00

Hi @Lawrence, Sharon I think this will require reviewing the backend telemetry. Can you please open a service case with the query you are trying to kill and the error message?

Regards
Geetha
Sign in to comment