From: | jscottb(at)InfoAve(dot)Net |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | First draft of pg_group admin tool. |
Date: | 1999-12-10 18:41:24 |
Message-ID: | Pine.PMDF.3.95.991210132947.606139951A-100000@InfoAve.Net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Well this is my first post to this list, so be gentle ;-). I have
written a small utility I use and wanted to get it out and better
tested :-)
With it you should be able to do most group amin, without going into psql.
It has the following syntax:
usage: pg_group options -- dB group [user ...] || [table ...]
where options is one of:
-c create group
-d delete group
-a add user(s) to group
-r remove user(s) to group
+g give group access to tables
-g revoke group access to tables
-p privlages to grant/revoke. This is only used with the +g and -g
options.
-- end of switches.
examples:
pg_group -c -- guestbook grp_gstbook_usr nobody tux
pg_group -a -- guestbook grp_gstbook_usr webuser
pg_group -d -- guestbook grp_gstbook_usr
pg_group -r -- guestbook grp_gstbook_usr nobody
pg_group +g -p "insert,select" -- guestbook grp_gstbook_usr gstbook
pg_group -g -p "insert" -- guestbook grp_gstbook_usr gstbook
you can get it from: http://www.lowcountry.com/~jscottb/pg_group.tar.gz.
If you have any questions, comments, patches or total rewrites email me
at: jscottb(at)infoave(dot)com
scott
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Beasley | 1999-12-10 18:52:36 | First draft of pg_group admin tool. |
Previous Message | Karl DeBisschop | 1999-12-10 18:09:18 | Mirroring a DB (was Re: [GENERAL] \d shows all my tables twice) |