Table_priv, Column_priv

[eddiev]

Hi, I am using mysql as my database server and while reading the 
documentation some questions regarding priviledges arose.

THe manual has a very good chapter 
(http://www.mysql.com/Manual_chapter/manual_Privilege_system.html#Privil
ege_system) about the priviledge system.

Unfortunately the information was somewhat confusing for me ( as for 
table_priv and column_priv).

Can you send me some examples of it's use ?
If I need to create two users, one with access to the whole database 
and another to specific tables how should I fill my mysql.db
(host,table_priv) tables ?
host = foo.com.br
user1 = joe - access to read,write all tables, foo database
user2 = jr - access to read bar1, bar2 tables from foo database
database = foo
tables = bar1, bar2, bar3

Thanks.

- EV

MailBR - O e-mail do Brasil -- http://www.mailbr.com.br
Faça já o seu. É gratuito!!!