[GENERAL] GRANT ALL ON * TO username?

From: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>
To: pg-gen <pgsql-general(at)postgresql(dot)org>
Subject: [GENERAL] GRANT ALL ON * TO username?
Date: 2000-01-14 22:51:59
Message-ID: 387FA88F.41F1F860@austin.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alfred Perlstein 2000-01-14 22:52:28 Re: [GENERAL] cgi with postgres
Previous Message Neil Burrows 2000-01-14 22:41:25 More Rule creation problems (and nowhere near 8K)