how to revoke multiple users permission from multiple tables at the same time?

From: DM <dm(dot)aeqa(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: how to revoke multiple users permission from multiple tables at the same time?
Date: 2009-04-22 22:19:27
Message-ID: eae6a62a0904221519x5abc9b20ne55c6eacb25e1c80@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

how to revoke multiple users permission from multiple tables at the same
time?
Or in simple is there a way to revoke multiple users grant access from
multiple tables under a schema.?

I use Revoke below command to execute on each table one by one.

revoke SELECT/ALL on testtable from user1;

Thanks for taking your time to read this.

thanks
Deepak

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2009-04-22 23:01:10 Re: how to revoke multiple users permission from multiple tables at the same time?
Previous Message Tom Lane 2009-04-22 20:47:08 Re: Logs say update done but not actually done or committed into database ???

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-04-22 22:52:15 Re: Help request to improve function performance
Previous Message Erik Jones 2009-04-22 22:14:57 Re: Yet another "drop table vs delete" question