List:General Discussion« Previous MessageNext Message »
From:Tim Little Date:March 30 2004 8:03pm
Subject:RE: How to get around lack of views?
View as plain text  
Wouldn't some variation on a MERGE table help with this?

-----Original Message-----
From: Jeremy Zawodny [mailto:Jeremy@stripped]
Sent: Tuesday, March 30, 2004 2:45 PM
To: Michael J. Pawlowsky
Cc: mysql@stripped
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 D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |

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:
To unsubscribe:
How to get around lack of views?Michael J. Pawlowsky29 Mar
  • RE: How to get around lack of views?Matt Chatterley30 Mar
  • Re: How to get around lack of views?Jeremy Zawodny30 Mar
RE: How to get around lack of views?Tim Little30 Mar