Re: Row-level security?
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Thu, 28 May 2009 20:58:46 -0300
Message-ID: <4a1f250b$0$23784$9a566e8b_at_news.aliant.net>
Date: Thu, 28 May 2009 20:58:46 -0300
Message-ID: <4a1f250b$0$23784$9a566e8b_at_news.aliant.net>
lawpoop wrote:
> On May 28, 4:00 pm, lawpoop <lawp..._at_gmail.com> wrote:
>
>>I don't think it does. The manual says that, for creating views, "The
>>SELECT statement cannot refer to system or user variables. "http://dev.mysql.com/doc/refman/5.0/en/create-view.html
>
> I just tried it, and I got the error, "View's SELECT contains a
> variable or parameter"
Without seeing the exact query, it's hard to say what's wrong.
One can create views that reference the user() function in mysql 5.0 Received on Fri May 29 2009 - 01:58:46 CEST