Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41555=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1VCsgL-0002Fg-Iz
 for pgsql-admin@arkaria.postgresql.org; Fri, 23 Aug 2013 14:49:45 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41555=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1VCsgL-0002gE-2m
 for pgsql-admin@arkaria.postgresql.org; Fri, 23 Aug 2013 14:49:45 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <salvator.barone@gmail.com>) id 1VCsgJ-0002g7-Sh
 for pgsql-admin@postgresql.org; Fri, 23 Aug 2013 14:49:44 +0000
Received: from mail-we0-x236.google.com ([2a00:1450:400c:c03::236])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <salvator.barone@gmail.com>) id 1VCsgC-0005fe-Li
 for pgsql-admin@postgresql.org; Fri, 23 Aug 2013 14:49:43 +0000
Received: by mail-we0-f182.google.com with SMTP id q59so636309wes.41
 for <pgsql-admin@postgresql.org>; Fri, 23 Aug 2013 07:49:35 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=message-id:disposition-notification-to:date:from:user-agent
 :mime-version:to:subject:content-type;
 bh=z1J1BmN5mFD+kL6qJ0QattYNvuVrqUPr1vd4XeReq9c=;
 b=ZPeruadrSonFXqj+YbInYwP6Ef0JauK5+Jhbkcx4Yb8ofqD1PMZhE+qvQpg+5o3+Zo
 bEqNk9JCzr4I4TOXLVZV/MnUlYQeSTwf0acKnKZwfmB0SDVqR7fnFAsq4sye2Jv7W0Xh
 lghXIlNAsr3Hct2q2jTybPaiW0DCpGjVzuB317qle7qaJSlNnb8u2YUQPmcvN/XrA+eY
 amPZfj90o5vh14OiMyc5vuWThk9WYOfPg0YPtyo7A4dQX7X0wkf4rsn4hSjb1t2RfNec
 jLwjisDPBiluhzM9Xw9RtokX0Rc4uigvC/6s9uBc/Skp+iSE3ehPcBwabq71vSseBHwy
 0lew==
X-Received: by 10.180.198.44 with SMTP id iz12mr55745wic.32.1377269375537;
 Fri, 23 Aug 2013 07:49:35 -0700 (PDT)
Received: from [192.168.1.3] ([151.77.181.153])
 by mx.google.com with ESMTPSA id dt17sm4522484wic.1.1969.12.31.16.00.00
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Fri, 23 Aug 2013 07:49:35 -0700 (PDT)
Message-ID: <52177664.5030908@gmail.com>
Date: Fri, 23 Aug 2013 16:49:08 +0200
From: Salvatore Barone <salvator.barone@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:17.0) Gecko/20130704 Icedove/17.0.7
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: question on the information_schema
Content-Type: multipart/alternative;
 boundary="------------030903030809000105070703"
X-Pg-Spam-Score: 0.7 (/)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.
--------------030903030809000105070703
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit

Hi all,
I created a database named "test" with the user "postgres" and I have
given all privileges on database "test" to a user that I use daily,
called "ssaa".
By submitting, as user "ssaa", to "test" database the «select * from
information_schema.columns with where col.table_schema! = 'Pg_catalog'
and col.table_schema! = 'Information_schema'» query, instead of the list
of columns, I have an empty table. I have to give some special permit
ssaa user?
How do I resolve?
Thanks.

Ps. I apologize for my poor english.


--------------030903030809000105070703
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <font size="+1"><tt><font size="+1">H</font>i all,<br>
        <font size="+1"><font size="+1">I created a database named
            "test" with the user "postgres" and I have given all
            privileges on database "test" to a user that I use daily,
            called "ssaa".<br>
            By submitting, as user "ssaa", to "test" database the
            &laquo;select * from information_schema.columns with where
            col.table_schema! = 'Pg_catalog' and col.table_schema! =
            'Information_schema'<font size="+1">&raquo; query, </font>instead
            of the list of columns, I have an empty table. I have to
            give some special permit ssaa user?</font><br>
          <font size="+1">How do I resolve?<br>
            Thanks.<br>
            <br>
          </font><font size="+1">Ps. I apologize for my poor english.<font
              size="+1"></font></font></font></tt></font><br>
    <br>
  </body>
</html>

--------------030903030809000105070703--