*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 <saddon...@yahoo.com.br> 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
