CREATE GROUP question
CREATE GROUP question
От:
"David Olbersen" <DOlbersen@stbernard.com>
Дата:
Hello all, Looking at the documentation for 7.3 I see that I can create a group and populate it with users at the same time: CREATE GROUP foo WITH USER joe, john, jane; Looking at the ALTER GROUP and CREATE GROUP documentation I only see "ADD|DROP USER" and "WITH USER" as options, nothing to do with other groups. What I'd like to do is create a group which contains groups. Can I do that at all? It doesn't look like it according to the documentation, and the question isn't raised. I tried searching the list archives at: http://archives.postgresql.org/search.php but never got results back as my browser waited forever for ads.area902.com to respond. A quick search on http://groups.google.com also didn't find what I was looking for. All help is appreciated. -------------------------- David Olbersen iGuard Engineer 11415 West Bernardo Court San Diego, CA 92127 1-858-676-2277 x2152
Re: CREATE GROUP question
От:
Bruno Wolff III <bruno@wolff.to>
Дата:
On Thu, May 22, 2003 at 15:04:19 -0700, David Olbersen wrote: > Hello all, > > Looking at the documentation for 7.3 I see that I can create a group and populate it with users at the same time: > > CREATE GROUP foo WITH USER joe, john, jane; > > Looking at the ALTER GROUP and CREATE GROUP documentation I only see "ADD|DROP USER" and "WITH USER" as options, nothing to do with other groups. > > What I'd like to do is create a group which contains groups. > Can I do that at all? It doesn't look like it according to the documentation, and the question isn't raised. I tried searching the list archives at: > http://archives.postgresql.org/search.php > but never got results back as my browser waited forever for ads.area902.com to respond. A quick search on http://groups.google.com also didn't find what I was looking for. The group commands doesn't allow for groups within groups. You can use expressions of the usernames on the group commands so you can't directly pull the data out of the database. What you could do is run a script that extracts group information out of the database and then rebuild the group lists. If you maintain the list in user tables you can even have a trigger that would run a function that would rebuild the groups for you. (You can't put triggers on system tables which is why the data needs to be in a user table to do this.)