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@michvhf.com http://www.pop4.net 56K Nationwide Dialup from $16.00/mo
atPop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore
http://www.cloudninegifts.com
==========================================================================
