First draft of pg_group admin tool.
От | Scott Beasley |
---|---|
Тема | First draft of pg_group admin tool. |
Дата | |
Msg-id | Pine.LNX.4.10.9912101350100.707-100000@cowbox.infoave.com обсуждение исходный текст |
Ответы |
Re: [HACKERS] First draft of pg_group admin tool.
|
Список | 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 groupaccess 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 -- guestbookgrp_gstbook_usr webuser pg_group -d -- guestbook grp_gstbook_usr pg_group -r -- guestbook grp_gstbook_usr nobodypg_group +g -p "insert,select" -- guestbook grp_gstbook_usr gstbook pg_group -g -p "insert" -- guestbook grp_gstbook_usrgstbook 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@infoave.com scott
В списке pgsql-hackers по дате отправления: