grant and SQL92
От | Vince Vielhaber |
---|---|
Тема | grant and SQL92 |
Дата | |
Msg-id | Pine.BSF.4.30.0106071012350.64208-100000@paprika.michvhf.com обсуждение исходный текст |
Ответы |
Re: grant and SQL92
Re: grant and SQL92 |
Список | 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@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 ==========================================================================
В списке pgsql-hackers по дате отправления: