Received: from capitular.tissat.es (capitular.tissat.es [195.77.30.34]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA24495 for ; Tue, 24 Aug 1999 05:18:41 -0400 (EDT) (envelope-from rperez@tissat.es) Received: from tissat.es ([195.77.30.16]) by capitular.tissat.es (Netscape Messaging Server 3.6) with ESMTP id AAAF59 for ; Tue, 24 Aug 1999 11:18:09 +0200 Message-ID: <37C26314.A2138870@tissat.es> Date: Tue, 24 Aug 1999 11:17:08 +0200 From: "Roberto Perez Lita" Organization: TISSAT Servicios avanzados de telecomunicaciones. X-Mailer: Mozilla 4.5 [es]C-telefonica (WinNT; I) X-Accept-Language: es, es-ES, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Accessing to a granted table. Content-Type: multipart/mixed; boundary="------------799A24B5522CBB751627ABC7" Este es un mensaje multipartes en formato MIME. --------------799A24B5522CBB751627ABC7 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi all, I have two users in a postgresql database, one is called user1 and the other user2. I have one table owned by the user1 which is called table1. I have granted the table1 to be selected by the user2. My question is: how can I access to table1 from the user2? I have tried from user2: SELECT * FROM USER1.TABLE1 but it doesn't work. Thanks in advance. Roberto Pérez. --------------799A24B5522CBB751627ABC7 Content-Type: text/x-vcard; charset=us-ascii; name="rperez.vcf" Content-Transfer-Encoding: 7bit Content-Description: Tarjeta de Roberto Pérez Lita Content-Disposition: attachment; filename="rperez.vcf" begin:vcard n:Pérez Lita;Roberto tel;fax:+ 34 96 393 99 01 tel;work:+ 34 96 393 99 50 x-mozilla-html:FALSE url:http://www.tissat.es org:Tissat, S.A.;Bases de datos version:2.1 email;internet:rperez@tissat.es adr;quoted-printable:;;Edificio Europa=0D=0AAvda. Aragon, 30 - 5=AA planta.;Valencia;;46021;Spain x-mozilla-cpt:;-1 fn:Roberto Pérez Lita end:vcard --------------799A24B5522CBB751627ABC7--