subject:"limiting acess by Triggers"

Re: limiting acess by Triggers

2010-05-06 Thread Prabhat Kumar

*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

limiting acess by Triggers

2010-05-06 Thread paulo matadr

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