Postgres Pro
Downloads
Home   >   mailing lists

how to revoke multiple users permission from multiple tables at the same time? - Mailing list pgsql-admin

From DM
Subject how to revoke multiple users permission from multiple tables at the same time?
Date
Msg-id eae6a62a0904221519x5abc9b20ne55c6eacb25e1c80@mail.gmail.com
Whole thread Raw
Responses Re: how to revoke multiple users permission from multiple tables at the same time?  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Logs say update done but not actually done or committed into database ???
Next
From: Scott Marlowe
Date:
Subject: Re: how to revoke multiple users permission from multiple tables at the same time?