Received: from zeus.houstoncellular.com (zeus.houstoncellular.com [206.109.152.194]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA86346 for ; Tue, 24 Aug 1999 11:39:32 -0400 (EDT) (envelope-from YoungblG@houstoncellular.com) Received: by SCORPGWY1.houstoncell.com with Internet Mail Service (5.5.2232.9) id ; Tue, 24 Aug 1999 10:33:47 -0500 Message-ID: <2B9713A99045D211BB4E0008C7566869DC9D7F@SCORPEXC1.houstoncell.com> From: Greg Youngblood To: "'Roberto Perez Lita'" , pgsql-sql@postgreSQL.org Subject: RE: [SQL] Accessing to a granted table. Date: Tue, 24 Aug 1999 10:38:32 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id LAA86382 Try dropping the "user1" in "user1.table1". Instead just "SELECT * FROM TABLE1". That is, if I understand the question correctly... Greg Gregory S. Youngblood ext 2164     > -----Original Message----- > From: Roberto Perez Lita [mailto:rperez@tissat.es] > Sent: Tuesday, August 24, 1999 4:17 AM > To: pgsql-sql@postgreSQL.org > Subject: [SQL] Accessing to a granted table. > > > 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. >