Re: grant to all tables
От | Robert Treat |
---|---|
Тема | Re: grant to all tables |
Дата | |
Msg-id | 1044049263.6685.59.camel@camel обсуждение исходный текст |
Ответ на | Re: grant to all tables (Bruce Momjian <pgman@candle.pha.pa.us>) |
Список | pgsql-general |
It's been discussed before and I think the current view point is that * it's not compliant with sql standards. * it can be worked around with stored procedures. I think the demand comes from mysql converts (as mysql allows non-standard grants). IIRC Oracle doesn't allow this (pretty sure up through the 8,x releases anyway). Robert Treat On Fri, 2003-01-31 at 00:18, Bruce Momjian wrote: > > Actually, he wants to grant permissions on all tables at once. Is this > a TODO item? Folks seem to want this. > > --------------------------------------------------------------------------- > > codeWarrior wrote: > > It's in the postgreSQL docs SQL Reference under GRANT but basically -- > > > > GRANT ALL ON tblNAME TO PUBLIC; > > > > > > "CSN" <cool_screen_name90001@yahoo.com> wrote in message > > news:20030121071754.57684.qmail@web40606.mail.yahoo.com... > > > Is there a way to grant to all tables in a database > > > with a single sql statement - such as: > > > > > > grant all on db.* to user; > > > > > > If not, how's it done? > > >
В списке pgsql-general по дате отправления: