saltstack-formulas/mysql-formula

[FEATURE] User access for columns

pawelrosada opened this issue · 1 comments

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

@pawelrosada Thanks for this feature request.

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

user:
frank:
password: 'somepass'
host: localhost
databases:
- database: foo
grants: ['select', 'insert', 'update']
escape: true