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: [EMAIL PROTECTED] 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
==========================================================================
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])