Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 294BA6327E6 for ; Thu, 8 Apr 2010 11:10:26 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 49312-03 for ; Thu, 8 Apr 2010 14:10:02 +0000 (UTC) X-Greylist: delayed 00:10:18.352332 by SQLgrey-1.7.6 Received: from webshield01.pjf.mg.gov.br (webshield01.pjf.mg.gov.br [201.7.117.199]) by mail.postgresql.org (Postfix) with SMTP id EE3DB632186 for ; Thu, 8 Apr 2010 11:10:05 -0300 (ADT) Received: from (unknown [192.168.254.5]) by webshield01.pjf.mg.gov.br with smtp id 55ba_28f6_b2052930_4316_11df_b4f2_002219d6be93; Thu, 08 Apr 2010 10:57:42 -0300 Received: from localhost (localhost [127.0.0.1]) by internet01.pjf.mg.gov.br (Postfix) with ESMTP id 691376C326; Thu, 8 Apr 2010 10:59:39 -0300 (BRT) X-Virus-Scanned: Debian amavisd-new at pjf.mg.gov.br Received: from internet01.pjf.mg.gov.br ([127.0.0.1]) by localhost (internet01.pjf.mg.gov.br [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id pnd4wjBm4Lby; Thu, 8 Apr 2010 10:59:39 -0300 (BRT) Received: from PJF123067 (unknown [10.0.12.49]) by internet01.pjf.mg.gov.br (Postfix) with SMTP id ECD2E6C325; Thu, 8 Apr 2010 10:59:38 -0300 (BRT) Message-ID: From: =?iso-8859-1?Q?Eduardo_S=E1_dos_Reis?= To: Cc: References: <1A57E5A7-AEB8-412B-B3A7-D52768F2FCF7@geysirit.dk> Subject: How to block access to a scheme Date: Thu, 8 Apr 2010 10:59:42 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000A_01CAD70A.977D0C40" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.5843 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579 X-NAI-Spam-Flag: NO X-NAI-Spam-Level: X-NAI-Spam-Threshold: 2 X-NAI-Spam-Score: 0.5 X-NAI-Spam-Rules: 2 Rules triggered FROM_NAME=0.5, RV3509=0 X-NAI-Spam-Version: 2.2.0.9149 : core <3509> : streams <432631> : uri <56984 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.126 tagged_above=-10 required=5 tests=BAYES_50=0.001, HTML_FONT_LOW_CONTRAST=0.124, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201004/84 X-Sequence-Number: 34178 This is a multi-part message in MIME format. ------=_NextPart_000_000A_01CAD70A.977D0C40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 also need to = disconnect users who are accessing the system. Grateful. Eduardo Reis ------=_NextPart_000_000A_01CAD70A.977D0C40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
How to block access to a = scheme

I=20 have a database with multiple schemas. I need to block access to a particular scheme = for doing=20 maintenance on the structure of your tables. Does anyone know how to block access to the = schema.=20 I also need to = disconnect users=20 who are accessing the system.

Grateful.

Eduardo=20 Reis
------=_NextPart_000_000A_01CAD70A.977D0C40--