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)
