The only idea which presents itself (be warned, this is ugly) is to maintain a set of tables which hold the same data, partitioned out by privilege, and to grant access on those tables to appropriate users.
These tables could be maintained (or recreated) from the source data at regular intervals. Leaves a lot to be desired though, since data consistency (and age) can become issues if updates are frequent... If the data is relatively static, it's just a bit messy. Regards, Matt -----Original Message----- From: Michael J. Pawlowsky [mailto:[EMAIL PROTECTED] Sent: 29 March 2004 21:58 To: [EMAIL PROTECTED] Subject: How to get around lack of views? 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
