From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
To: pgsql-admin@postgresql.org
Cc: felipe_lt@yahoo.com.br
Subject: Re: How to block access to a scheme
Date: Thu, 08 Apr 2010 09:53:48 -0500
Message-ID: <4BBDA7AC0200002500030589@gw.wicourts.gov> (raw)
In-Reply-To: <EF75DFD93ED8426DBD604A45461B8A9E@PJF123067>
References: <1A57E5A7-AEB8-412B-B3A7-D52768F2FCF7@geysirit.dk>
<EF75DFD93ED8426DBD604A45461B8A9E@PJF123067>
Eduardo Sá dos Reis<eduardoreis@pjf.mg.gov.br> wrote:
> How to block access to a scheme
>
> I have a database with multiple schemas. I need to block access to
> a particular scheme for doing maintenance on the structure of your
> tables. Does anyone know how to block access to the schema.
I'm not sure I exactly understand, but you can probably find
something on this page that will help:
http://www.postgresql.org/docs/8.4/interactive/sql-revoke.html
Perhaps this?:
REVOKE ALL ON SCHEMA x FROM y;
> I also need to disconnect users who are accessing the system.
http://www.postgresql.org/docs/8.4/interactive/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL-TABLE
Before using these functions, you probably want to modify the
pg_hba.conf file and signal a reload, to block new logins.
-Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, eduardoreis@pjf.mg.gov.br, felipe_lt@yahoo.com.br
Subject: Re: How to block access to a scheme
In-Reply-To: <4BBDA7AC0200002500030589@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox