Re: Problem whith table views.

From: Jan Wieck <janwieck(at)yahoo(dot)com>
To: Nicolas Bouthors <nicolas(at)bouthors(dot)org>
Cc: Jan Wieck <janwieck(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org, sbourgeois(at)ghs(dot)fr
Subject: Re: Problem whith table views.
Date: 2002-01-15 15:34:21
Message-ID: 200201151534.g0FFYLP28706@saturn.janwieck.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)Yahoo(dot)com #

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Meskes 2002-01-15 15:37:33 Re:
Previous Message Justin Clift 2002-01-15 15:29:51 PostgreSQL 7.1.3 recovery tool "pg_check" no longer works