Re: Making a schema "read-only" (was Unexpected message in grant/revoke script)

From: Erik Jones <erik(at)myemma(dot)com>
To: "Webb Sprague" <webb(dot)sprague(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Making a schema "read-only" (was Unexpected message in grant/revoke script)
Date: 2008-03-14 20:30:52
Message-ID: 53C1DB48-D813-48B3-ACD5-D16E5399EC65@myemma.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Mar 14, 2008, at 3:22 PM, Webb Sprague wrote:

>>> Start with
>>> revoke all on schema public from public
>>> and then grant only what you want.
>
> Oh -- to grant select permissions on all the tables in the public
> schema, do I have to do it table-by-table? I know I can write a loop
> an use information_schema if necessary, but if I don't have to I would
> like to know.
>
> Thx

Typically what's done is to do that for one user "group" and then make
all of your actual login users members of that group.

Erik Jones

DBA | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Webb Sprague 2008-03-14 20:43:17 Re: Making a schema "read-only" (was Unexpected message in grant/revoke script)
Previous Message Kynn Jones 2008-03-14 20:28:00 How to silence psql notices, warnings, etc.?