search

saltstack-formulas / mysql-formula

Install the MySQL client and/or server
http://docs.saltstack.com/en/latest/topics/development/conventions/formulas.html
Other
85 stars 369 forks source link

[FEATURE] User access for columns #235

Open pawelrosada opened 4 years ago

pawelrosada commented 4 years ago

Describe the solution you'd like

MySQL offer access to specific column. It would be useful to manage this from the formula level. For example you can do it like:

user:
    frank:
      password: 'somepass'
      host: localhost
      databases:
        - database: foo
          grants: ['select', 'insert']
          table: foobar
             - column: col
               grants: ['update']
myii commented 4 years ago

@pawelrosada Thanks for this feature request.

For anyone looking at this, the current pillar.example section is as follows:

https://github.com/saltstack-formulas/mysql-formula/blob/b4f5f79781631d7d31061b880df3066ac5bc5860/pillar.example#L108-L115