> > Hi, I read the book, but there is not explain about it. > > I would like to know when I give privileges to the user, in the table > level, and after I give privileges in the database level. Do I replace > the privileges?
Any time you execute a query, MySQL looks for the privileges needed for execute that query in the tables of the database mysql in the following order: user->db->host->tables_priv->columns_priv When MySQL finds the privileges that you need for that query it stops the searching and execute the query. It means that if the privileges are found in the table 'db' it execute the query without searching them in the next tables (tables_priv and columns_priv) ----------------------------------------- Facultad de Matemática y Computación. "Universidad de Oriente. Cuba " http://csd.uo.edu.cu/mail/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
