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

From Ed Loehr
Subject [GENERAL] GRANT ALL ON * TO username?
Date
Msg-id 387FA88F.41F1F860@austin.rr.com
Whole thread Raw
Responses Re: [GENERAL] GRANT ALL ON * TO username?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Neil Burrows
Date:
Subject: More Rule creation problems (and nowhere near 8K)
Next
From: Kevin Heflin
Date:
Subject: problem with date range