Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

No message is displayed if a user with no privilege to terminate a query tries to do so on query tool. #7480

Closed
pravesh-sharma opened this issue May 16, 2024 · 1 comment
Assignees
Milestone

Comments

@pravesh-sharma
Copy link
Contributor

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

  1. Create a role B which can not log in to the server.
  2. Create another role A which can log in to the server and is a member of role B.
  3. Go to the query tool and execute a long-running query. Now click on the cancel query button.
  4. Observe the connection status it says A command is currently in progress. and the execute script button is now enabled.
  5. 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
@pravesh-sharma pravesh-sharma self-assigned this May 30, 2024
pravesh-sharma added a commit to pravesh-sharma/pgadmin4 that referenced this issue May 30, 2024
pravesh-sharma added a commit to pravesh-sharma/pgadmin4 that referenced this issue May 30, 2024
akshay-joshi pushed a commit that referenced this issue May 31, 2024
@akshay-joshi akshay-joshi added this to the 8.8 milestone May 31, 2024
@RohitBhati8269
Copy link
Contributor

Tested and verified on candidate build: https://developer.pgadmin.org/builds/2024-06-05-1/
Environment: MacOs

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants