[MDEV-17602] Allow max_statement_time to be assigned via role Created: 2018-11-02  Updated: 2023-11-16

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

Type: Task Priority: Minor
Reporter: Kyle Joiner (Inactive) Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 2
Labels: None

Issue Links:
Duplicate
duplicates MDEV-20405 It should be possible to preset resou... Closed
duplicates MDEV-20733 Allow roles to impose limits Closed
duplicates MDEV-24928 resource limit options for roles Closed

 Description   

Allow max_statement_time to be assigned via a role.

We can assign max_statement_time to users, not roles.
GRANT USAGE ON . TO 'rajas018'@'%' WITH max_statement_time 10; --working
GRANT USAGE ON . TO `mysqlread` WITH max_statement_time 10; – not working

 Comments   
Comment by Vicențiu Ciorbaru [ 2018-11-04 ]

Would this involve doing max(user, role)'s max_statement_time ? What about when no limit is used?

Comment by Ulrich Moser (Inactive) [ 2019-08-23 ]

The extension should include all user-specific resource restrictions that are part of the GRANT statement not just max_statement_time

Generated at Thu Feb 08 08:37:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.