limiting acess by Triggers

--0-717054940-1273155870=:75799
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi all ,=0AIm new on mysql,how can block update column of specif table f=
or a user "x" by trigger in mysql?=0AIs possible deny acess for columns =
on mysql? =0Aversion: 5.0.77 Regards =0A
--0-717054940-1273155870=:75799--

Re: limiting acess by Triggers

--0016363b802ce31f690485ede322
Content-Type: text/plain; charset=ISO-8859-1

*Column Privileges*

Column privileges apply to single columns in a given table. Each privilege
to be granted at the column level must be followed by the column or columns,
enclosed within parentheses.

GRANT SELECT (col1), INSERT (col1,col2) ON mydb.mytbl TO 'someuser'@'somehost';

The allowable *priv_type* values for a column (that is, when you use a *
column_list* clause) are
INSERT,
SELECT,
and UPDATE.


Column privileges are stored in the mysql.columns_priv table.

http://dev.mysql.com/doc/refman/5.1/en/grant.html

Thanks,


On Thu, May 6, 2010 at 7:54 PM, paulo matadr wrote:

> Hi all ,
> Im new on mysql,how can block update column of specif table for a user
> "x" by trigger in mysql?
> Is possible deny acess for columns on mysql?
>
>
> version: 5.0.77
>
> Regards
>
>
>




--
Best Regards,

Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

--0016363b802ce31f690485ede322--