From: | "Roberto Perez Lita" <rperez(at)tissat(dot)es> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Accessing to a granted table. |
Date: | 1999-08-24 09:17:08 |
Message-ID: | 37C26314.A2138870@tissat.es |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
Attachment | Content-Type | Size |
---|---|---|
rperez.vcf | text/x-vcard | 357 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Clayton Cottingham | 1999-08-24 10:00:08 | out of memory error on dumping over 1,000,000 to file |
Previous Message | Rudy Gireyev | 1999-08-24 08:24:54 | Re: [SQL] 2 million+ entries |