Postgres Pro
Downloads
Home   >   mailing lists

Thread: [GENERAL] GRANT ALL ON * TO username?

[GENERAL] GRANT ALL ON * TO username?

From
Ed Loehr
Date:
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?

Cheers,
Ed Loehr

Re: [GENERAL] GRANT ALL ON * TO username?

From
Peter Eisentraut
Date:
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