Grant privileges

[robb73]

Just wanted to check a couple of things.

 

I have a simple database where SELECT is required on all tables and INSERT on only one table.

 

Would the the right way to do this be with two GRANT statements:

 

GRANT SELECT ON database.* TO 'user'@'localhost' IDENTIFIED BY 'password';

 

GRANT INSERT ON database.table TO 'user'@'localhost' IDENTIFIED BY 'password';

 

 

My second question is GRANT ALL is specified as granting all simple privileges, I'm struggling to find a list of these on the mysql website.

 

Rob

[gluck]

You can do the first way. No harm