Wouldn't some variation on a MERGE table help with this?
From: Jeremy Zawodny [mailto:Jeremy@stripped]
Sent: Tuesday, March 30, 2004 2:45 PM
To: Michael J. Pawlowsky
Subject: Re: How to get around lack of views?
On Mon, Mar 29, 2004 at 03:58:29PM -0500, Michael J. Pawlowsky wrote:
> How would I do this?
> Let say I have an employee table with
> Name varchar(64)
> Dept int(11);
> Salary int(11);
> I want to grant select on Salary to a mysql user but only where dept = 1
> Normally I would create a view to do something like this.
> But I was wondering if there would be another way around this until
> views are implemented that someone has thought of.
Honestly, if you need views at the db level, MySQL is not for you.
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 198 days, processed 3,393,557,554 queries
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1