Обсуждение: [GENERAL] GRANT ALL ON * TO username?

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

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