[MDEV-20405] It should be possible to preset resource restrictions in role definition Created: 2019-08-22  Updated: 2019-10-06  Resolved: 2019-08-22

Status: Closed
Project: MariaDB Server
Component/s: Authentication and Privilege System
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Ulrich Moser (Inactive) Assignee: Sergei Golubchik
Resolution: Duplicate Votes: 0
Labels: GRANT, Roles, resources

Issue Links:
Duplicate
duplicates MDEV-20733 Allow roles to impose limits Closed
is duplicated by MDEV-17602 Allow max_statement_time to be assign... Open

 Description   

MAX_USER_CONNECTIONS can be set per account. When authorizing accounts through roles I would expect that it is possible to restrict all users having the same role in the same way without needing to issue a separate GRANT USAGE ON . to user@host WITH ...

Therefore it should be possible to preset the restriction in the role definition like
GRANT USAGE ON . TO rolename WITH MAX_USER_CONNECTIUONS 2;


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