Postgres Pro
Downloads
Home   >   mailing lists

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

From Erik Jones
Subject Re: Making a schema "read-only" (was Unexpected message in grant/revoke script)
Date
Msg-id 53C1DB48-D813-48B3-ACD5-D16E5399EC65@myemma.com
Whole thread Raw
In response to Re: Making a schema "read-only" (was Unexpected message in grant/revoke script)  ("Webb Sprague" <webb.sprague@gmail.com>)
Responses Re: Making a schema "read-only" (was Unexpected message in grant/revoke script)  ("Webb Sprague" <webb.sprague@gmail.com>)
List pgsql-general
Tree view 
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@myemma.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

pgsql-general by date:

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