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

From: "Webb Sprague" <webb(dot)sprague(at)gmail(dot)com>
To:
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:22:14
Message-ID: b11ea23c0803141322w8788ceax535615b78372904e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> > 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kynn Jones 2008-03-14 20:28:00 How to silence psql notices, warnings, etc.?
Previous Message Dave Page 2008-03-14 20:08:48 Re: postgre vs MySQL