Re: How to block access to a scheme - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: How to block access to a scheme
Date
Msg-id 4BBDA7AC0200002500030589@gw.wicourts.gov
Whole thread Raw
In response to How to block access to a scheme  (Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Autovacuum daemon functionality questions
Next
From: Jonathan Foy
Date:
Subject: Re: PD_ALL_VISIBLE flag warning