summaryrefslogtreecommitdiff
path: root/mysql-test/t/grant.test
Commit message (Collapse)AuthorAgeFilesLines
* Bug#14406 GRANTS ON objects with non-ascii names borked after FLUSH PRIVILEGESbar@mysql.com2005-11-141-0/+12
| | | | | | | | | | | | | | ps_grant.result: Fixing result order. grant.result: Adding test case, fixing result order. grant.test: Adding test case. sql_acl.cc: Fixed that my_charset_latin1 was incorrectly used instead of system_charset_info. This problem was previously fixed by Ingo in 5.0. This patch is basically a backport of the same changes into 4.1.
* grant.result, grant.test:bar@mysql.com2005-08-041-0/+7
| | | | | | | | | fixing tests accordingly item.cc: Bug #10892 user variables not auto cast for comparisons When mixing strings with different character sets, and coercibility is the same, we allow conversion if one character set is superset for other character set.
* Added end marker for tests to make future merges easiermonty@mysql.com2005-07-281-0/+2
|
* Fix test casesjimw@mysql.com2005-07-051-1/+2
|
* Fix crash when an entry was added to the mysql.tables_privjimw@mysql.com2005-06-201-0/+8
| | | | table with an empty hostname. (Bug #11330)
* Shift skipping of some tests with embedded server from withinjimw@mysql.com2005-03-291-0/+3
| | | | mysql-test-run to the tests themselves.
* Re-enable alter_table test for embedded server by moving grant-related testjimw@mysql.com2005-02-091-0/+20
| | | | | to grant.test and using replace_column to neuter the Privileges column in SHOW FULL COLUMNS.
* Manual merge of changes making GRANTs, which change SSL attributes and/ordlenev@mysql.com2004-12-231-0/+17
|\ | | | | | | user limits to behave well on 5.0 tables, into 4.1 tree.
| * Make GRANTs, which change SSL attributes and/or user limits,dlenev@mysql.com2004-12-231-0/+17
| | | | | | | | | | | | | | to behave well on 5.0 tables (well now you can't use tables from 4.1 and 5.0 with 4.0 because former use utf8, but still it is nice to have similar code in acl_init() and replace_user_table()). This also will make such GRANTs working in 5.0 (they are broken now).
* | Merge Bug#7391 from 4.0antony@ltantony.rdg.cyberkinetica.homeunix.net2004-12-181-0/+72
|\ \ | |/
| * Bug#7391 - Multi-table UPDATE security regressionantony@ltantony.rdg.cyberkinetica.homeunix.net2004-12-181-0/+72
| | | | | | | | | | Add in missing privilege checks. Tests for the privileges.
* | Fixes (bug #6932: 'revoke all privileges...' doesn't remove all proper ↵ram@gw.mysql.r18.ru2004-12-021-0/+13
| | | | | | | | | | | | columns from columns_priv bug #6933: error in the tests/grant.pl test).
* | merge with 4.0monty@mysql.com2004-11-121-15/+24
|\ \ | |/
| * Bug#6123 - GRANT USAGE creates useless mysql.db rowacurtis@pcgem.rdg.cyberkinetica.com2004-11-111-0/+9
| | | | | | | | | | Prevent creation of a row which grants no rights Test included
* | grant.test, grant.result, sql_acl.cc:dellis@goetia.(none)2004-10-011-0/+40
| | | | | | | | BUG #5831 Changed mysql_revoke_all() to successfully delete all privileges for a user in one pass.
* | logging_ok:dellis@goetia.(none)2004-10-011-0/+29
| | | | | | | | | | | | Logging to logging@openlogging.org accepted sql_acl.cc, grant.test, grant.result: BUG 5831 Changed mysql_revoke_all() to successfully delete all privileges for a user in one pass.
* | manually mergedserg@serg.mylan2004-08-181-0/+16
|\ \ | |/
| * Added initial sorting in order to make test case repeatable. ram@gw.mysql.r18.ru2004-08-121-0/+1
| |
| * A test case (bug #4898: User privileges depending on ORDER BY Settings of ↵ram@gw.mysql.r18.ru2004-08-121-0/+15
| | | | | | | | table db)
* | Bug#4338: mysql-test-run fails if compiled with non-latin1 character setbar@mysql.com2004-07-081-0/+2
| |
* | Bug #3403 Wrong encoding in SHOW GRANTS, EPLAIN SELECT outputbar@bar.intranet.mysql.r18.ru2004-05-141-0/+23
| | | | | | | | | | This change fixes SHOW GRANTS problem, while EXPLAIN will be fixed in a separate patch.
* | Moved reading of ranges from opt_range.cc to handler.ccmonty@mysql.com2004-04-081-0/+2
| | | | | | | | | | This gives the handler more optimization possiblities and is needed for NDB cluster Fixed not-initialized memory error detected by valgrind
* | Fix for bug#3086: SHOW GRANTS doesn't follow ANSI_QUOTESgluh@gluh.mysql.r18.ru2004-03-171-0/+17
| |
* | fix for a bug #2953.Sinisa@sinisa.nasamreza.org2004-03-011-0/+4
| | | | | | | | | | | | When password was granted with a global grant, then granting privileges on database level, without password being specified, will temporary (in memory) set password to ''.
* | Merge with public treemonty@mysql.com2004-02-161-2/+2
|\ \
| * | After merge fixesmonty@mysql.com2004-02-161-2/+2
| | | | | | | | | | | | | | | | | | | | | Added more DBUG statements Ensure that we are comparing end space with BINARY strings Use 'any_db' instead of '' to mean any database. (For HANDLER command) Only strip ' ' when comparing CHAR, not other space-like characters (like \t)
* | | REVOKE ALL PRIVILEGES, GRANT FROM user_listserg@serg.mylan2004-02-151-4/+4
|/ / | | | | | | | | | | is changed to a more consistent REVOKE ALL PRIVILEGES, GRANT OPTION FROM user_list. Bug #2642
* | merge with 4.0.15monty@mashka.mysql.fi2003-09-111-16/+16
|\ \ | |/
| * Cleaned up last bug fixesmonty@mashka.mysql.fi2003-09-091-16/+16
| | | | | | | | Fix bug in SHOW GRANTS when there is a column privilege but no table privilege
* | merge with 4.0.15monty@narttu.mysql.fi2003-08-291-0/+10
|\ \ | |/
| * After merge fixesSinisa@sinisa.nasamreza.org2003-08-221-0/+5
| |\
| | * Cleanups to recent patchesmonty@mashka.mysql.fi2003-08-151-0/+5
| | | | | | | | | | | | Fix packet error when using wrong GRANT command
| * | grant.result, grant.test, sql_acl.cc:Sinisa@sinisa.nasamreza.org2003-08-221-0/+10
| |/ | | | | | | Fix for a bug #878
* | After merge fixesmonty@mashka.mysql.fi2003-08-191-5/+11
| | | | | | | | | | Use server character set if --default-character-set is not used Added convert_string() for more efficient alloc+character-set convert of strings
* | Merge with 4.0.14monty@mashka.mysql.fi2003-08-111-2/+31
|\ \ | |/
| * Some fixes for CREATE / INSERT FROM UNIO >..Sinisa@sinisa.nasamreza.org2003-07-021-1/+1
| |
| * Lot's of clean-ups and fixes for 4.0.14.Sinisa@sinisa.nasamreza.org2003-07-021-0/+2
| |
| * SHOW GRANTS hided real grants when grants on both column and table (Bug 654)monty@narttu.mysql.fi2003-06-231-2/+32
| |
* | REVOKE all privileges and delete user(244)gluh@gluh.mysql.r18.ru2003-06-061-0/+38
|/
* Fix for a bug in SHOW GRANTS when :Sinisa@sinisa.nasamreza.org2003-01-111-0/+3
| | | | | | | grant on database.* to xx@yy with grant option; is done.
* Added CREATE TEMPORARY TABLES and LOCK TABLES to db and host tablesmonty@mashka.mysql.fi2002-09-161-0/+19
| | | | | | Fixed bug in SELECT ... ORDER BY ... LIMIT Fixed bug in ALTER TABLE and RENAME TABLE with --lower-case-table-names Fixed hang when using --with-openssl
* Portability fixes.monty@mashka.mysql.fi2002-09-111-0/+1
| | | | | | | Improve mysql-test to be more robust. Fix that GRANT doesn't delete SSL options Change innobase_flush_log_at_trx_commit to uint. Don't rotate logs if we read a rotate log entry from the master.
* Fixed searching after ssl directories.monty@mashka.mysql.fi2002-09-051-0/+21
Fixed that GRANT ... REQUIRE options are not forgot when doing new GRANT Changed fn_ext to point at first '.' after directory. FLUSH LOGS removed numerical extension for all future update logs. Fixed the mysqld --help reports right values for --datadir and --bind-address --log-binary=a.b.c now properly strips of .b.c Fix that one can DROP UDF functions that was not loaded at startup Made AND optional in REQUIRE Added REQUIRE NONE