Postgres as a Service

Question

Lawrence, Sharon 1

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

Answer 1

GeethaThatipatri-MSFT 17,131 Microsoft Employee

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

Oury Ba-MSFT 10,331 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 17,131 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

1 answer