From: | Raj Mathur <raju(at)linux-delhi(dot)org> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Users and groups |
Date: | 2003-02-14 03:51:14 |
Message-ID: | 15948.26546.900701.127373@mail.linux-delhi.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)kandalaya(dot)org http://kandalaya.org/
It is the mind that moves
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-02-14 04:16:54 | Re: Users and groups |
Previous Message | Uday Singh | 2003-02-14 03:19:47 | Re: Can I make Postgresql to bind to 127.0.0.1:5432, inst |