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







-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to