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.