From: | Vince Vielhaber <vev(at)michvhf(dot)com> |
---|---|
To: | <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | grant and SQL92 |
Date: | 2001-06-07 14:23:51 |
Message-ID: | Pine.BSF.4.30.0106071012350.64208-100000@paprika.michvhf.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
In process of converting a bunch of scripts from sybase to postgresql
I see something that doesn't make much sense..
I can grant a series of privileges (comma separated) on a series of
objects (comma separated) to either a user, group or public NOT a
comma separated list of users or groups. Yet at the bottom of the
man page for grant
http://www.postgresql.org/idocs/index.php?sql-grant.html
it says it's allowed in SQL92. How is it this isn't allowed in
postgresql, is it a real pain to implement or was it just never
needed?
I'm trying to come up with a way to do this:
grant all on xydata09 to vwonly,mngmnt,remusr,supusr,dbmngr,schdlr,intusr
on about 500 tables on the fly. Not all of them are the same permissions
per table but each file that creates a table has this and a couple of
revoke lines in it.
Workarounds?
Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com http://www.pop4.net
56K Nationwide Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-06-07 14:34:33 | Re: AW: Re: [SQL] behavior of ' = NULL' vs. MySQL vs. Stand ards |
Previous Message | Peter Eisentraut | 2001-06-07 14:16:33 | Re: Re: [PATCHES] Fw: Isn't pg_statistic a security hole - Solution Proposal |