diff options
| author | salle@vafla.online.bg <> | 2003-11-05 14:35:08 +0200 |
|---|---|---|
| committer | salle@vafla.online.bg <> | 2003-11-05 14:35:08 +0200 |
| commit | e51d0ced6198b409c67f5239f15543fc2d1daaa4 (patch) | |
| tree | 34e54da5825ba80373307eec6924fd154784bf6b | |
| parent | ac8ac9ad04654f26d1aa88f82e9147ed3bb0b851 (diff) | |
| download | mariadb-git-e51d0ced6198b409c67f5239f15543fc2d1daaa4.tar.gz | |
Fix for Bug #1752 Wrong letter cases.
Thanks to Daniel Convissor
| -rw-r--r-- | BitKeeper/etc/logging_ok | 1 | ||||
| -rw-r--r-- | scripts/mysql_fix_privilege_tables.sql | 4 |
2 files changed, 3 insertions, 2 deletions
diff --git a/BitKeeper/etc/logging_ok b/BitKeeper/etc/logging_ok index f642821747f..9dea6a7fa44 100644 --- a/BitKeeper/etc/logging_ok +++ b/BitKeeper/etc/logging_ok @@ -96,6 +96,7 @@ ranger@regul.home.lan root@x3.internalnet salle@geopard.(none) salle@geopard.online.bg +salle@vafla.online.bg sasha@mysql.sashanet.com serg@build.mysql2.com serg@serg.mylan diff --git a/scripts/mysql_fix_privilege_tables.sql b/scripts/mysql_fix_privilege_tables.sql index 1120f5c89c5..2ea2e5b7373 100644 --- a/scripts/mysql_fix_privilege_tables.sql +++ b/scripts/mysql_fix_privilege_tables.sql @@ -101,7 +101,7 @@ SET @hadShowDbPriv:=0; SELECT @hadShowDbPriv:=1 FROM user WHERE Show_db_priv LIKE '%'; ALTER TABLE user -ADD Show_db_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER alter_priv, +ADD Show_db_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Alter_priv, ADD Super_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Show_db_priv, ADD Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Super_priv, ADD Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Create_tmp_table_priv, @@ -112,7 +112,7 @@ ADD Repl_client_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Repl_slave_priv; -- Convert privileges so that users have similar privileges as before -UPDATE user SET show_db_priv= select_priv, super_priv=process_priv, execute_priv=process_priv, create_tmp_table_priv='Y', Lock_tables_priv='Y', Repl_slave_priv=file_priv, Repl_client_priv=file_priv where user<>"" AND @hadShowDbPriv = 0; +UPDATE user SET Show_db_priv= Select_priv, Super_priv=Process_priv, Execute_priv=Process_priv, Create_tmp_table_priv='Y', Lock_tables_priv='Y', Repl_slave_priv=file_priv, Repl_client_priv=File_priv where user<>"" AND @hadShowDbPriv = 0; -- Add fields that can be used to limit number of questions and connections |