puppetlabs/puppetlabs-mysql

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.