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! <[EMAIL PROTECTED]> | 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/[EMAIL PROTECTED]
