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

From Jan Wieck
Subject Re: Problem whith table views.
Date
Msg-id 200201151534.g0FFYLP28706@saturn.janwieck.net
Whole thread Raw
In response to Re: Problem whith table views.  (Nicolas Bouthors <nbouthors@ghs.fr>)
Responses Re: Problem whith table views.  (Nicolas Bouthors <nbouthors@ghs.fr>)
Re: Problem whith table views.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Nicolas Bouthors wrote:
> 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

    Do you do the CREATE, GRANT allways as the same user?


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


pgsql-general by date:

Previous
From: Michael Meskes
Date:
Subject: Re:
Next
From: Nicolas Bouthors
Date:
Subject: Re: Problem whith table views.