Access control functions for PostgreSQL

PostgreSQL provides a number of access control options, but granting privileges en masse can be difficult. For example, the GRANT command requires that each table be explicitly listed in the statement. To overcome this, Andrew Hammond and Tim Goodaire created some SQL functions to simplify this and several other administration tasks related to access control.

There has been significant discussion on the PostgreSQL hackers list about improving the GRANT and REVOKE syntax, so perhaps there will be other options available in the near future.

Resources: