~egtann/sum

declarative user management in sql
2660c9cf — Evan Tann a month ago
remove unused make clean command
cbabcb2e — Evan Tann a month ago
split make and make install
9074303a — Evan Tann a month ago
rename project from sf to sum

refs

master
browse  log 

clone

read-only
https://git.sr.ht/~egtann/sum
read/write
git@git.sr.ht:~egtann/sum

You can also use your local clone with git send-email.

sum(1)

sum(1) ("SQL user manager") declaratively configures user roles and permissions in SQL databases. Its configuration is based heavily on the syntax of pf firewall in OpenBSD.

sum(1) works around incredible shortcomings in MySQL user management, but it may be useful for other databases as well. Currently there's only support for MySQL but patches for additional databases are welcome.

See this article on SQL User Management to understand the rational for this.

Install

$ git clone git@git.sr.ht:~egtann/sum && cd sum
$ sudo make install

After installation, check the man pages for usage information for sum(1) and sum.conf(5).

Contact

To report bugs, discuss functionality or submit patches, email this list.

TODO

  • quoted values, e.g. multi-word statement "alter routine"
  • combine users into the permissions struct to simplify code?
  • more tests
  • Postgres, MariaDB, MySQL v8 support