Re: Problem whith table views.

From: Nicolas Bouthors <nbouthors(at)ghs(dot)fr>
To: Jan Wieck <janwieck(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, sbourgeois(at)ghs(dot)fr
Subject: Re: Problem whith table views.
Date: 2002-01-15 14:53:07
Message-ID: 20020115145307.GH18452@lavardac.int.ghs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jan Wieck said :
>> > But when apache tries to SELECT from one view it works fine, but on the
>> > other one it fails.
>>
>> Define 'fails'

"Permission denied".

And when I grant "select" on the table, selecting from the view works.
Whithout any grant selecting from the other view works fine.

Nico

--
nicolas(at)bouthors(dot)org -- http://nicolas.bouthors.org/ -- +33 6 2071 6234
Administateur Systèmes et Réseaux -- GHS -- 38, Rue du Texel

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2002-01-15 15:29:51 PostgreSQL 7.1.3 recovery tool "pg_check" no longer works
Previous Message Marc G. Fournier 2002-01-15 14:51:27 PostgreSQL v7.2b5 Released