List:General Discussion« Previous MessageNext Message »
From:Prabhat Kumar Date:May 6 2010 2:38pm
Subject:Re: limiting acess by Triggers
View as plain text  
*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

Thread
limiting acess by Triggerspaulo matadr6 May
  • Re: limiting acess by TriggersPrabhat Kumar6 May