Re: grant everything on everything and then revoke

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: grant everything on everything and then revoke
Date: 2009-03-03 15:36:53
Message-ID: 244A766F-9453-4473-AD21-42AFF299360D@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Mar 3, 2009, at 4:35 AM, Ivan Sergio Borgonovo wrote:

> But I read:
>
> http://www.postgresql.org/docs/8.3/static/sql-grant.html
> The SQL standard does not support setting the privileges on more
> than one object per command.
>
> This is going to make maintenance and development a PITA every time I
> add a new table, sequence, schema...

There is some pl/pgsql code here grant on more than one object at a
time:

http://pgedit.com/tip/postgresql/access_control_functions

John DeSoi, Ph.D.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A. Rich 2009-03-03 15:39:54 Re: how to use pg_dump to dump tables whose owner is me
Previous Message Роман Маширов 2009-03-03 15:31:30 Re: date - null casted to integer?