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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden