RE: How to get around lack of views?
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]
Re: How to get around lack of views?
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]
RE: How to get around lack of views?
Wouldn't some variation on a MERGE table help with this? -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 30, 2004 2:45 PM To: Michael J. Pawlowsky Cc: [EMAIL PROTECTED] Subject: Re: How to get around lack of views? 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]