Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem whith table views. - Mailing list pgsql-general

From Nicolas Bouthors
Subject Re: Problem whith table views.
Date
Msg-id 20020115145307.GH18452@lavardac.int.ghs
Whole thread Raw
In response to Problem whith table views.  (Nicolas Bouthors <nbouthors@ghs.fr>)
Responses Re: Problem whith table views.  (Jan Wieck <janwieck@yahoo.com>)
List pgsql-general
Tree view 
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@bouthors.org -- http://nicolas.bouthors.org/ -- +33 6 2071 6234
Administateur Systèmes et Réseaux   --    GHS    --    38, Rue du Texel

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re:
Next
From: "Marc G. Fournier"
Date:
Subject: PostgreSQL v7.2b5 Released