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 firstname.lastname@example.org:~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.
permissionsstruct to simplify code?