*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<http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_insert>,
SELECT<http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_select>,
and
UPDATE<http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_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 <saddoness@stripped> 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
