> Hi Scott, > > One would think that you should be able to accomplish what you are > looking for by changing rows in table -> "tables_priv" in mysql > database. And using "flush privileges" when you done.
So does this mean my database privs of select, insert, update, and delete supercede any table specific ones? I am trying to not have to add new table privs every time I add a new table. That would be kind of a hassle. My goal is to have a set of tables, that are accessible to 10 mysql users, there will then be 10 additional tables in that database, each user is allowed to access only a certain one. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]