Revoke privilege from multiple tables

From: "Aaron Dummer" <aaron(at)xtratyme(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Revoke privilege from multiple tables
Date: 2003-07-07 00:38:34
Message-ID: 00fa01c34420$191ae0e0$f0dc0a0a@aaron
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello list,

I'd like to give a user only SELECT privileges, database-wide. Is there an easy way to do this? I could execute a REVOKE ALL PRIVILEGES command for each table, then execute a GRANT SELECT command for each table, but that is tedious.

It would be great to do something like this:

REVOKE ALL PRIVILEGES ON * FROM user_name
GRANT SELECT ON * TO user_name

Please help me.

Aaron Dummer

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Martin Foster 2003-07-07 04:21:29 Re: [PERFORM] Extreme high load averages
Previous Message Martin Foster 2003-07-06 20:28:48 Re: [PERFORM] Extreme high load averages