> # mysqlmgr add database www1 > # mysqlmgr add user www1 password xxx > # mysqlmgr allow user www1 database www1 read write define
I suppose in some cases this is OK, and I'm sure you will test thoroughly! :-) One thing to bear in mind is that if you define a user and then revoke his privileges, his account details details will still persist in the user Grant table. This may not be a worry to you since he cannot get at any database resource. To remove any trace of him, you must delete him from the user table. (if you're playing with MySQL 5.0 then DROP USER is the ticket). Final thing, as you're a MySQL admin type writing an access control app, you want to know when the priv changes take effect. You will probably find this info useful: http://dev.mysql.com/doc/refman/5.0/en/privilege-changes.html Hope that helps, Imran Chaudhry -- http://www.EjectDisc.com Get your Digital Identity - Domain Names, Web Space, E-mail & More! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
