How to get around lack of views?

[Michael J. Pawlowsky]

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.

Thanks,
Mike