At 18:12 -0800 2/28/04, Scott Haneda wrote:
When from 3 to 4, ran the update_privs_table thngy...
All my users used to say Global Privileges USAGE now they are all
CREATE TEMPORARY TABLES, LOCK TABLES I am not sure this is good or bad,
nor am I sure how these settings got in there.
They got there when you updated the grant tables.
What are your suggestions? I don't think I want any user able to LOCK
tables, these are global so I assume all databases are able to be locked by
all users.
Whats the best way to udpate all these back to the USAGE they were at
before.
--
UPDATE user SET Create_tmp_table_priv = 'N', Lock_tables_priv = 'N', ... ;
FLUSH PRIVILEGES;
You might want to add WHERE User != 'root' to that, if you don't
want root accounts to have those privileges disabled.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]