On Sun, 1999-10-03 20:22:14 +0000, eddiev@stripped wrote:
> THe manual has a very good chapter
> ege_system) about the priviledge system.
> Unfortunately the information was somewhat confusing for me ( as for
> table_priv and column_priv).
What has been confusing to you? What information do you think is
missing? (The MySQL team only can make things better, if they get to
know where the weak points are ...)
> 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
In contrast to earlier versions of MySQL, where you had to change the
privilege tables directly, starting with version 3.22.11 there is the
GRANT command, that does all changes to these tables automatically!
(There still is at least one case where manual changes are necessary,
if you want wildcards in the db fields of mysql.db)
So to solution for the task given above is:
GRANT SELECT, INSERT, UPDATE, DELETE
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=5244 5EF3 B0B1 3826 E4EC 8058 7B31 3AD7