[MDEV-5379] Roles and performance schema Created: 2013-12-03  Updated: 2015-11-04

Status: Open
Project: MariaDB Server
Component/s: Authentication and Privilege System
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Federico Razzoli Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

performance_schema ignores roles. This is a feature request, but a new user would probably think this is a bug.

1) performance_schema.threads has a ROLE column, but it's always NULL.
2) When a user connects, a matching row is searched in performance_schema.setup_actors, including the ROLE column. However, the check is never re-done after connection, even if the user sets a role. In practice, a row with ROLE <> '%' will never match anything.

 Comments   
Comment by Federico Razzoli [ 2013-12-03 ]

Maybe I should explain the reason for this request.

setup_actors lets me decide what threads are [not] instrumented, based on user/host. But I want to instrument the threads which perform some actions, and the best way to identify them is specifying their role.

Generated at Thu Feb 08 07:03:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.