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

[Peter Eisentraut]

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
[EMAIL PROTECTED]                   75262 Uppsala
http://yi.org/peter-e/            Sweden



************