Syntax to Add and Delete Access

[madeline1]

what is the correct syntax to grant just add and delete to a column in a table? I am using MySQL.

It is not Grant all? So I am not sure how to specify just the add and delete to a particular column within a table.

Any advice is appreciated!

 

[vacunita]

You can specify individual actions for the user:

GRANT INSERT, DELETE ON 'x' TO 'username';

Though You'll likely also want to let the user SELECT, otherwise they'll only be able to INSERT and DELETE, but not view what they've inserted afterward.

Also you might want to read the "GRANT" entry in the MYSQL Online manual:

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

----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[madeline1]

Thanks, that is what I thought it was!