Re: [GENERAL] GRANT ALL ON * TO username? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: [GENERAL] GRANT ALL ON * TO username?
Date
Msg-id Pine.LNX.4.21.0001152020430.386-100000@localhost.localdomain
Whole thread Raw
In response to [GENERAL] GRANT ALL ON * TO username?  (Ed Loehr <eloehr@austin.rr.com>)
List pgsql-general
On 2000-01-14, Ed Loehr mentioned:

> I'd like to grant read-access to every single DB object in a database
> for one user.  I'd hoped for
>
>     GRANT SELECT ON * TO <username>
>
> but the '*' syntax is wrong and I don't see an alternative in the
> docs...
>
> How is this done?

The standard doesn't allow this either. You'd have to do some scripting
magic.

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



pgsql-general by date:

Previous
From: Marc Tardif
Date:
Subject: attribute level rules not supported?
Next
From: Peter Eisentraut
Date:
Subject: Re: Re[2]: [GENERAL] case-insensitive like operator