Thread: select users in a group?
Howdy:
I'm running Postgres 7.1.3 on RedHat Linux 2.4.7-rel 10.
How can I get a list of the users in a group? For example,
I created a group called 'staff' ... I know there are five people
I created a group called 'staff' ... I know there are five people
in this group, but how can I *see* everyone in this group?
Thanks!
-X
--WAIT ... I'm sorry ... by bad ...
--I'm looking at the table pg_group and I see
the group 'staff' listed ... along the lines, I see
what I can only assume is the UID-ish numbers
of the users that are in the group.
--NOW ... I want to go from THAT point to figuring
out who those people are ...
--Hope I caught this in time ...
-X
-----Original Message-----Howdy:I'm running Postgres 7.1.3 on RedHat Linux 2.4.7-rel 10.How can I get a list of the users in a group? For example,
I created a group called 'staff' ... I know there are five peoplein this group, but how can I *see* everyone in this group?Thanks!-X
On Wed, 17 Apr 2002, Johnson, Shaunn wrote: > --WAIT ... I'm sorry ... by bad ... > > --I'm looking at the table pg_group and I see > the group 'staff' listed ... along the lines, I see > what I can only assume is the UID-ish numbers > of the users that are in the group. > > --NOW ... I want to go from THAT point to figuring > out who those people are ... > > --Hope I caught this in time ... > > -X > > -----Original Message----- > > > Howdy: > > I'm running Postgres 7.1.3 on RedHat Linux 2.4.7-rel 10. > > How can I get a list of the users in a group? For example, > I created a group called 'staff' ... I know there are five people > in this group, but how can I *see* everyone in this group? > > Thanks! > > -X > > Now, it's just a suggestion as I've not used arrays before but have you tried something like: SELECT u.usename FROM pg_user u WHERE EXISTS (SELECT 1 FROM pg_group g WHERE g.grolist *= u.usesysid); You should look up arrays in the documentation since I see from there that the *= operator is probably an extension you need to install. -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants
Those numbers are user id's. If you look in pg_user you will see the numbers of each user. Now, we really should have a way of listing the users in a group more easily. Added to TODO: * Allow easy display of usernames in a group --------------------------------------------------------------------------- Nigel J. Andrews wrote: > > > On Wed, 17 Apr 2002, Johnson, Shaunn wrote: > > > --WAIT ... I'm sorry ... by bad ... > > > > --I'm looking at the table pg_group and I see > > the group 'staff' listed ... along the lines, I see > > what I can only assume is the UID-ish numbers > > of the users that are in the group. > > > > --NOW ... I want to go from THAT point to figuring > > out who those people are ... > > > > --Hope I caught this in time ... > > > > -X > > > > -----Original Message----- > > > > > > Howdy: > > > > I'm running Postgres 7.1.3 on RedHat Linux 2.4.7-rel 10. > > > > How can I get a list of the users in a group? For example, > > I created a group called 'staff' ... I know there are five people > > in this group, but how can I *see* everyone in this group? > > > > Thanks! > > > > -X > > > > > > Now, it's just a suggestion as I've not used arrays before but have you tried > something like: > > SELECT u.usename FROM pg_user u WHERE EXISTS (SELECT 1 FROM pg_group g WHERE > g.grolist *= u.usesysid); > > You should look up arrays in the documentation since I see from there that the > *= operator is probably an extension you need to install. > > > -- > Nigel J. Andrews > Director > > --- > Logictree Systems Limited > Computer Consultants > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Hello all, I am in the investigation phase of a potential project that would automaticly update a novell Netware server's user accounts with information stored on PostgreSQL Database running on a linux box through a perl script. Currently Netware has support for Database Independent Interface (DBI) NetWare Data Object (NDO) UCX Component Remote ActiveX Provider and ADO Component on Windows machine Through DBI, Netware can remotely connect to Oracle on NetWare or MS-Access, SQL Server and Oracle, all on Windows Is anybody out there familure enough with dbi and Novell to be able to tell me how I can get a perl script running on Netware to connect to a PostgreSQL/Linux box. Or if it is way to complicated / know one knows. Please send an e-mail to Enhancements@novell.com to ask that they add PostgreSQL support to Netware. Thanks Jeff Post