Hi,
Using PostgreSQL 7.2.3 on a Linux box and facing some minor issues
with determining which groups users belong to.
I have created a PgSQL group called `administrators'. Now when I need
to check whether user X is a member of that group, I use the
contrib/array_iterator operator to do something like,
select groname from pg_group where grolist **=
( select usesysid from pg_user where usename = 'X' ) ;
This works just fine. However, the complementary process, determining
all the users in group administrators, isn't so clean. Currently I'm
brute-forcing it, getting each user in turn and then checking whether
she belongs to group administrators using the construct above.
Is there a simpler way?
Also, are there any caveats attached to using the pg_ system tables
directly? I prefer to do that to prevent duplication of user status:
let PgSQL store whether the user is an administrator or not rather
than have another table keeping that information. However, I'd change
that if the structure of the pg_ tables is subject to change from time
to time.
Regards,
-- Raju
--
Raj Mathur raju@kandalaya.org http://kandalaya.org/
It is the mind that moves
