Wouldn't some variation on a MERGE table help with this?
-----Original Message-----
From: Jeremy Zawodny [mailto:Jeremy@stripped]
Sent: Tuesday, March 30, 2004 2:45 PM
To: Michael J. Pawlowsky
Cc: mysql@stripped
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
let's say.
>
> 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
--
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
(197/sec. avg)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
