aclexplode

Synopsis

aclexplode is a backport of PostgreSQL 9.0 aclexplode functions to earlier versions of PostgreSQL.

Description

The main purpse of aclexplode function is to convert the relacl array from pg_class row into the new representation, that can be easily parsed or interpreted by the user. Each result row consists of grantor and grantee OIDs, text description of the given privilege (i.e INSERT, TRUNCATE and so on) and a flag, defining whether the grantee is allowed to grant the privilege to another role.

This module was sponsored by Enova Financial (http://www.enova.com)

Usage

postgres=# select (aclexplode(relacl)).* from pg_class where relname='test'; grantor | grantee | privilege_type | is_grantable ---------+---------+----------------+-------------- 10 | 10 | INSERT | f 10 | 10 | SELECT | f 10 | 10 | UPDATE | f 10 | 10 | DELETE | f 10 | 10 | TRUNCATE | f 10 | 10 | REFERENCES | f 10 | 10 | TRIGGER | f 10 | 16385 | INSERT | f 10 | 16385 | UPDATE | f (9 rows)

Support

support@commandprompt.com

Author

Alvaro Herrera, Command Prompt, Inc.

Copyright and License

Copyright (c) 2012 Command Prompt, Inc.