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
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.
>
> Norma
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.