pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Accessing to a granted table.
2+ messages / 2 participants
[nested] [flat]

* Accessing to a granted table.
@ 1999-08-24 09:17  Roberto Perez Lita <rperez@tissat.es>
  0 siblings, 0 replies; 2+ messages in thread

From: Roberto Perez Lita @ 1999-08-24 09:17 UTC (permalink / raw)
  To: pgsql-sql

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.

Attachments:

rperez.vcf (text/x-vcard, 356B) download 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
^ permalink raw reply [nested|flat] 2+ messages in thread

* RE: [SQL] Accessing to a granted table.
@ 1999-08-24 15:38  Greg Youngblood <YoungblG@houstoncellular.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Greg Youngblood @ 1999-08-24 15:38 UTC (permalink / raw)
  To: 'Roberto Perez Lita' <rperez@tissat.es>; pgsql-sql

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.
> 



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-08-24 15:38 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-08-24 09:17 Accessing to a granted table. Roberto Perez Lita <rperez@tissat.es>
1999-08-24 15:38 RE: [SQL] Accessing to a granted table. Greg Youngblood <YoungblG@houstoncellular.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox