diff options
| author | Bruce Momjian | 2004-04-26 15:06:49 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2004-04-26 15:06:49 +0000 |
| commit | 0a17fd726ca50d04d99395addbbc89e6dfa5be31 (patch) | |
| tree | 0d5617708f5b180622cbd279e92d6d0f2e1122da /src/test | |
| parent | 9cb7b76ec7a3e6bb661550848a5dac6c9c0accbd (diff) | |
Please find a attached a small patch that adds accessor functions
for "aclitem" so that it is not an opaque datatype.
I needed these functions to browse aclitems from user land. I can load
them when necessary, but it seems to me that these accessors for a
backend type belong to the backend, so I submit them.
Fabien Coelho
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/privileges.out | 14 | ||||
| -rw-r--r-- | src/test/regress/sql/privileges.sql | 9 |
2 files changed, 23 insertions, 0 deletions
diff --git a/src/test/regress/expected/privileges.out b/src/test/regress/expected/privileges.out index f5a6c039d54..fe1b8483a65 100644 --- a/src/test/regress/expected/privileges.out +++ b/src/test/regress/expected/privileges.out @@ -581,6 +581,20 @@ SELECT has_table_privilege('regressuser1', 'atest4', 'SELECT WITH GRANT OPTION') t (1 row) +-- aclitem utils small test +SELECT u1.usename AS u1, u2.usename AS u2, + aclitem_idtype(c.relacl[0]) AS idtype, + aclitem_privs(c.relacl[0]) AS privs, + aclitem_goptions(c.relacl[0]) AS goptions +FROM pg_class AS c, pg_user AS u1, pg_user AS u2 +WHERE u1.usesysid = aclitem_grantor(c.relacl[0]) + AND u2.usesysid = aclitem_grantee(c.relacl[0]) + AND c.relname LIKE 'atest4'; + u1 | u2 | idtype | privs | goptions +--------------+--------------+--------+-------+---------- + regressuser1 | regressuser1 | 1 | 127 | 127 +(1 row) + -- clean up \c regression DROP FUNCTION testfunc2(int); diff --git a/src/test/regress/sql/privileges.sql b/src/test/regress/sql/privileges.sql index d3e9b543035..dd33295277a 100644 --- a/src/test/regress/sql/privileges.sql +++ b/src/test/regress/sql/privileges.sql @@ -316,6 +316,15 @@ SELECT has_table_privilege('regressuser3', 'atest4', 'SELECT'); -- false SELECT has_table_privilege('regressuser1', 'atest4', 'SELECT WITH GRANT OPTION'); -- true +-- aclitem utils small test +SELECT u1.usename AS u1, u2.usename AS u2, + aclitem_idtype(c.relacl[0]) AS idtype, + aclitem_privs(c.relacl[0]) AS privs, + aclitem_goptions(c.relacl[0]) AS goptions +FROM pg_class AS c, pg_user AS u1, pg_user AS u2 +WHERE u1.usesysid = aclitem_grantor(c.relacl[0]) + AND u2.usesysid = aclitem_grantee(c.relacl[0]) + AND c.relname LIKE 'atest4'; -- clean up |