Re: grant everything on everything and then revoke - Mailing list pgsql-general

From John DeSoi
Subject Re: grant everything on everything and then revoke
Date
Msg-id 244A766F-9453-4473-AD21-42AFF299360D@pgedit.com
Whole thread Raw
In response to grant everything on everything and then revoke  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List 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.





pgsql-general by date:

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