Re: Problems with GRANTING SELECT to a table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Amin Schoeib" <aschoeib(at)4tek(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems with GRANTING SELECT to a table
Date: 2003-09-02 14:13:14
Message-ID: 27290.1062511994@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Amin Schoeib" <aschoeib(at)4tek(dot)de> writes:
> Here is what I did:
> test=3D> GRANT SELECT ON "poi"."fondsstamm" TO "flex";
> Now when I try to select from the table poi.fondsstamm
> I become always the error: Permission denied,

Did you grant usage on the schema "poi" ?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message psql-mail 2003-09-02 14:14:27 postmaster segfault with tsearch2?
Previous Message Jonathan Bartlett 2003-09-02 13:52:07 Re: About GPL and proprietary software