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

Cannot create grants with different tags #1545

Open
wimvr opened this issue Mar 21, 2023 · 0 comments
Open

Cannot create grants with different tags #1545

wimvr opened this issue Mar 21, 2023 · 0 comments

Comments

@wimvr
Copy link

wimvr commented Mar 21, 2023

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.

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

2 participants