Cannot create grants with different tags
wimvr opened this issue · 0 comments
wimvr commented
Describe the Bug
It is not possible to make different versions of the same grant, but with different tags when exporting.
Expected Behavior
The possibility to add multiple mysql_grant statements for the same user/table combination, but with different tag.
Steps to Reproduce
@@mysql_grant { 'user@localhost/*.*":
ensure => 'present',
table => '*.*'
privileges => ['SELECT'],
user => 'user@localhost',
tag => 'readonly',
}
@@mysql_grant { 'user@localhost/*.*":
ensure => 'present',
table => '*.*'
privileges => ['SELECT', 'INSERT', 'UPDATE', 'DELETE'],
user => 'user@localhost',
tag => 'readwrite',
}
This is not allowed due to the unique constraint on name. When changing the name, you get the error 'mysql_grant: name parameter must match user@host/table format.'
Environment
- Version 13.2.0
- Platform AlmaLinux 8
Additional Context
Only an issue with exported resources.