Simple Question about MYSQL

Hi, I had a question about how permissions work in MYSQL. Could you make it so:

1. A certain account ONLY has permission to modify a specific table.

2. Could you make it so it can access table x, HOWEVER, it can only access a specific SECTION of that table (for example, ordernumber but NOT username)

3. Could to make it so it only has access to do certain things. For example, so it can only SELECT a variable in table X, however, it can modify a variable in Table Y.

Thank you.

 

 

 

 

Top