ref: cbabcb2e0a3a616d1008f7dc2ed03163272e378f sum/README.md -rw-r--r-- 1011 bytes
cbabcb2e — Evan Tann split make and make install 4 months ago


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.


$ 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).


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


  • 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