pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedAccessing 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