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
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |  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/mysql?unsub=1
Thread
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