You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the bug
Suppose there is a user who is a member of another role who does not have the privilege to cancel a query runs a long query and then tries to cancel it he won't be able to as the role does not have the privilege but there is no message or notification is displayed for the same.
To Reproduce
Create a role B which can not log in to the server.
Create another role A which can log in to the server and is a member of role B.
Go to the query tool and execute a long-running query. Now click on the cancel query button.
Observe the connection status it says A command is currently in progress. and the execute script button is now enabled.
If you access the logs an error is there Error Message:must be a member of the role whose query is being canceled or member of pg_signal_backend.
Expected behavior
Execute script button should not be enabled as the query is still executing and an error message should be displayed that the query was not cancelled.
Attaching screen recording
Screen.Recording.2024-05-16.at.1.59.19.PM.mov
Desktop (please complete the following information):
OS: macOS 14
Version: 8.6
Mode: Desktop
The text was updated successfully, but these errors were encountered:
Describe the bug
Suppose there is a user who is a member of another role who does not have the privilege to cancel a query runs a long query and then tries to cancel it he won't be able to as the role does not have the privilege but there is no message or notification is displayed for the same.
To Reproduce
A command is currently in progress.
and the execute script button is now enabled.Error Message:must be a member of the role whose query is being canceled or member of pg_signal_backend
.Expected behavior
Execute script button should not be enabled as the query is still executing and an error message should be displayed that the query was not cancelled.
Attaching screen recording
Screen.Recording.2024-05-16.at.1.59.19.PM.mov
Desktop (please complete the following information):
The text was updated successfully, but these errors were encountered: