grant and SQL92

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
==========================================================================

Responses

Browse pgsql-hackers by date

  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