Re: Problem whith table views.

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