Thank you Shawn! 2006/2/7, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: > > > Célio Cidral Junior <[EMAIL PROTECTED]> wrote on 02/05/2006 02:20:48 > PM: > > There already IS a users table that you can either send CRUD statements to > or manage through the GRANT and REVOKE statements. Since MySQL security also > gets down to the column level, there is a table for each level of user > permissions: user, db, tables_priv, and columns_priv. The appropriate > records and settings in those tables determines the access rights (the ACL) > for native MySQL user accounts. > > Because these are "system" tables, they are not guaranteed to exist from one > version to another nor are the columns' names or purposes guaranteed to stay > the same between releases. You can directly edit them as you see fit but you > must remember to issue a FLUSH PRIVILEGES command in order for your changes > to take immediate effect. > > The parts of the manual pertinent to your task: > > http://dev.mysql.com/doc/refman/4.1/en/security.html > http://dev.mysql.com/doc/refman/4.1/en/privilege-system.html > http://dev.mysql.com/doc/refman/4.1/en/user-account-management.html > http://dev.mysql.com/doc/refman/4.1/en/account-management-sql.html > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
