diff options
| author | unknown <mysqldev@mysql.com> | 2005-03-22 15:54:18 +0100 |
|---|---|---|
| committer | unknown <mysqldev@mysql.com> | 2005-03-22 15:54:18 +0100 |
| commit | 30a232784887340ad43aa5a5e24451415b9daef8 (patch) | |
| tree | 4152dc14986a84db418b76d506d7a9fd168dd514 /scripts/mysql_fix_privilege_tables.sql | |
| parent | 135979d9593f412e4b119a76830fe44adf8950c4 (diff) | |
| download | mariadb-git-30a232784887340ad43aa5a5e24451415b9daef8.tar.gz | |
sql_acl.cc, sql_acl.h, sql_parse.cc
New privilege CREATE USER (CREATE_USER_ACL, Create_user_priv) added
grant2.test:
new tests (mostly backported from jani's patch)
system_mysql_db.result, sp.result, grant2.result, grant.result:
results updated
mysql-test/r/grant.result:
results updated
mysql-test/r/grant2.result:
results updated
mysql-test/r/sp.result:
results updated
mysql-test/r/system_mysql_db.result:
results updated
mysql-test/t/grant2.test:
new tests (mostly backported from jani's patch)
scripts/mysql_create_system_tables.sh:
Create_user_priv added
scripts/mysql_fix_privilege_tables.sql:
Create_user_priv added
sql/sql_acl.cc:
Create_user_priv added
sql/sql_acl.h:
Create_user_priv added
sql/sql_parse.cc:
Create_user_priv added
sql/sql_show.cc:
Create_user_priv added
sql/sql_yacc.yy:
Create_user_priv added
BitKeeper/etc/logging_ok:
Logging to logging@openlogging.org accepted
Diffstat (limited to 'scripts/mysql_fix_privilege_tables.sql')
| -rw-r--r-- | scripts/mysql_fix_privilege_tables.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/scripts/mysql_fix_privilege_tables.sql b/scripts/mysql_fix_privilege_tables.sql index 2310e8d0bef..628b034362d 100644 --- a/scripts/mysql_fix_privilege_tables.sql +++ b/scripts/mysql_fix_privilege_tables.sql @@ -291,6 +291,18 @@ UPDATE db SET Create_routine_priv=Create_priv, Alter_routine_priv=Alter_priv, Ex ALTER TABLE user ADD max_user_connections int(11) unsigned DEFAULT '0' NOT NULL AFTER max_connections; # +# user.Create_user_priv +# + +SET @hadCreateUserPriv:=0; +SELECT @hadCreateUserPriv:=1 FROM user WHERE Create_user_priv LIKE '%'; + +ALTER TABLE user ADD Create_user_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Alter_routine_priv; +UPDATE user LEFT JOIN db USING (Host,User) SET Create_user_priv='Y' + WHERE @hadCreateUserPriv = 0 AND + (user.Grant_priv = 'Y' OR db.Grant_priv = 'Y'); + +# # Create some possible missing tables # CREATE TABLE IF NOT EXISTS procs_priv ( |