125 Commits

Author SHA1 Message Date
5a8a4af29a Rename helpers unit to apphelpers, to overcome a naming conflict with the FireMonkey unit FMX.Canvas.GPU.Helpers. Closes #102. 2018-01-22 19:48:17 +01:00
ade0bd3f44 Support multiple objects selected in user manager > add object. 2016-08-29 18:37:00 +00:00
0ec226ce47 Do not complain about empty password when SHOW GRANTS output does not include the IDENTIFIED BY clause on MySQL 5.7.6+. See http://www.heidisql.com/forum.php?t=21351 2016-06-06 17:57:28 +00:00
1ffe9d00ef User manager: Allow double quotes in SHOW GRANTS output, to support ANSI mode. See http://www.heidisql.com/forum.php?t=19757 2015-11-27 18:12:17 +00:00
d02f9822b3 User manager: Select "authentication_string" instead of "password" column on MySQL 5.7.6+. See http://www.heidisql.com/forum.php?t=18650 2015-06-28 10:25:29 +00:00
9fc3c2a3bc Overtake username and hashed password from old user when cloning a user. See http://www.heidisql.com/forum.php?t=8943 2014-03-30 05:31:34 +00:00
75695bc90a Revert previous commit and handle VIEWs exactly as we handle tables in user management, except for the icon in front of the privilege, which we detect so the user can distinct between tables and views. 2014-03-03 18:26:33 +00:00
9c5a53445b Support VIEW privileges in user manager. Seems that MySQL has 3 of it: DROP, SHOW VIEW, CREATE VIEW - but does not distinct the GRANT commands to those of TABLE grants. So, we distinct views from tables by watching out if there is a view with the relevant name. Fixes issue #2732. 2014-03-03 05:21:15 +00:00
e8990c6447 Clone hostname for a cloned user. See http://www.heidisql.com/forum.php?t=14681 2014-01-29 09:09:07 +00:00
b22fa249f2 Allow localhost users to be edited again with the usermanager, in skip-name-resolve mode - localhost still seems to be a special case. Fixes issue #3472. 2013-12-18 05:30:21 +00:00
c8e5121b66 Attempt to fix an 64bit-only access violation 2013-11-13 18:48:55 +00:00
6e608f157e Replace out-dated code which does not compile in 64bit mode in helpers.SetWindowSizeGrip. Use a TForm descendant in the new unit "extra_controls". Code parts taken from http://www.delphigroups.info/2/4/326787.html 2013-11-01 14:54:13 +00:00
438281fe5f Extend detection of requirement to name resolving in user manager, to allow netmasks. Also, "localhost" is no longer auto-resolved via libmysql.dll. Fixes issue #3205. 2013-05-30 06:05:44 +00:00
056322c488 Expect dots in database and table names, when parsing SHOW GRANTS results. See http://www.heidisql.com/forum.php?t=12640 2013-05-11 05:15:11 +00:00
b29e24b5d4 Do not complain about an empty password when having modified anything but the password of an existing user. 2012-12-08 21:36:33 +00:00
d52d304361 Adjust width of even some more controls so they fit to the translated captions (at least in German). See https://www.transifex.com/messages/view/22056/ 2012-12-08 10:56:58 +00:00
9d8b4cd83a Make more inline strings translatable. 2012-11-28 23:27:31 +00:00
f96288fce9 Translate string variables and literals in .pas files. TODO: translate constants. 2012-11-26 05:44:01 +00:00
ca1d94c87b Issue #557: Include gnugettext.pas from https://dxgettext.svn.sourceforge.net/svnroot/dxgettext/trunk/dxgettext/sample/ . And add basic code to all FormCreate events to translate their components in the future. 2012-11-10 14:28:44 +00:00
f54c3634a6 Update blank password warning in user manager after updating user with a modified password, or vice versa. Fixes issue #3001. 2012-10-27 08:23:23 +00:00
90ab0b6cf1 Refactor logic for reading and writing application and session settings:
* Introduce TAppSettings, created in dpr file
* Implement read and write methods, and replace callers of GetRegValue and MainReg.WriteInt/... with these
* Optimize read and write methods for avoiding redundant accesses to registry
* Auto-remove stored default settings from registry to avoid registry spam
* Replace synced MainForm.pref* variables with TAppSettings.Read* calls
* Move SetLocales call to dpr file
* Move MainForm.FDirname* variables to appropriate methods in helpers.pas
* Implement TQueryHistory.Create(SessionPath), reading its items within constructor
2012-08-19 10:55:08 +00:00
1858c04d82 Usermanager: Host may contain uppercase chars, it's just case sensitive, as stated on http://bugs.mysql.com/bug.php?id=19828 . Allow uppercase host names, which may cause errors when selecting such users, but as we have a exit-logic here that does not show AVs to the end user. 2012-04-06 09:03:26 +00:00
75e69ec3ab Detect --skip-name-resolve server option in usermanager, and disable users where that would cause "There is no such grant..." errors when firing "SHOW GRANTS FOR ...". On older servers there is no server variable for that detection, so as a fallback the "SHOW GRANTS FOR ..." errors are try/caught and the user node gets disabled lately. See r4101 and http://www.heidisql.com/forum.php 2012-04-01 09:30:40 +00:00
66f9ead0f0 Avoid AV when trying to focus username edit box in cases where tabCredentials is not the active tab. 2012-03-29 13:59:13 +00:00
269d3a0791 Revert r4101 - instead, do a FLUSH PRIVILEGES when the user manager dialog is opened, to ensure that non-flushed users can be edited. Users with uppercase chars in their host name cannot be edited - disable such nodes with a hint on how to manually fix that. 2012-03-27 23:17:20 +00:00
500472970a User manager: Check grants *before* tree node has focus. Could be a non-flushed user, since we just SELECT them from mysql.user. Catch such "There is no such grant defined for user" errors and disable tree node in that case. See http://www.heidisql.com/forum.php?t=10364 2012-03-24 07:40:26 +00:00
b271ea2670 Find GRANT OPTION also when SSL requirements are set. Fixes issue #2671. 2012-02-05 07:04:41 +00:00
6325d42c4b Fix enabled controls which should be disabled when no SSL option selected. 2012-01-07 09:13:13 +00:00
84d27865e2 Fix mixed up GRANT privilege in user manager, caused by errors and high complexity in regular expression. See issue #2671. Revert modification in SynRegExpr.pas again, now that we have only about 10 parentheses left. 2012-01-06 01:03:12 +00:00
aedbb997ab Support GRANT .. REQUIRE syntax in user manager with a new "SSL options" tab. Fixes issue #2671. 2012-01-05 20:44:49 +00:00
1f75acc999 Fix non-overtaken grants when user clicks "clone user". See http://www.heidisql.com/forum.php?t=8943 2011-07-30 08:20:51 +00:00
48ed802352 Usermanager: Support CREATE TABLESPACE privilege in MySQL 5.4.4 and up. See 5.4 manual for version. And add TODO for different syntax of GRANT PROXY. 2011-07-22 05:02:31 +00:00
d0f7e7f505 Support account resources limits in user manager. Fixes issue #2492. 2011-07-14 19:54:37 +00:00
133b2a265c Refactor code for Host subtabs: Remove TVTreeData structure, use TDBQueryList instead. Use same code for most grid events. 2011-07-03 08:44:20 +00:00
e96fa77cbd Do not cache dialog instances any longer. OnCreate code is mostly very quick, and caching them adds quite some pitfalls into the code. Not to mention 30 lines less code in main.pas now :) 2011-06-26 20:01:42 +00:00
2d548b5ef6 Introduce some wrapper functions for message and error dialogs in order to have less code and to avoid hidden titles on Windows XP. Fixes issue #2425. 2011-05-27 04:48:21 +00:00
2c9e2edc9d Create users list after querying mysql.user, so when that query returns an error, a later check for existence of the user list can decide to close the user manager. Fixes issue #2414 2011-05-14 05:36:38 +00:00
0bba145162 Silence error message about invalid password length after changing a users' password. Fixes issue #2346. 2011-04-05 22:38:23 +00:00
4fbf2c23dd Introduce experimental MS SQL support 2011-03-29 23:20:21 +00:00
49a97584e6 Code preparation for non-MySQL connections: Extract abstract stuff into a new TDBConnection class, and let TMySQLConnection derive from that. Same with TDBQuery / TMySQLQuery. See issue #1008. 2011-03-17 23:03:54 +00:00
de2767711d Flush privileges after user has been dropped. 2011-02-14 09:30:47 +00:00
216f097d9c Servers up to 5.0.6 do not support the object type in a GRANT or REVOKE query. See http://www.heidisql.com/forum.php?t=7753 2011-02-09 23:22:48 +00:00
08513f1d88 Improve user manager: Include inactive users in users list and disable these nodes. Just to make clear they exist, and the user should fix them manually. 2011-02-05 07:23:43 +00:00
ca58d88410 Improve password generator on user manager dialog: Create a drop down menu containing groups of passwords in several lengths. Do not automatically copy to clipboard, and leave the password visible as long as the user did not type manually. 2011-02-05 06:37:43 +00:00
95f50b9ca5 Improve user manager: Add drop down menu to "From host" input, containing some predefined hosts plus all unique ones from the users list. 2011-02-03 23:50:01 +00:00
374e79448f New user object does not update its user name and host, so the save button granted privileges to some "Unnamed" user, which was probably named differently by the user. So, update the user object with current input before saving. Fixes issue #2294. 2011-02-03 23:03:40 +00:00
ba9d971e02 Apply added privs which were in org privs, then deleted, and added again. Fixes issue #2284. 2011-01-30 23:44:43 +00:00
6988d82c55 User manager: Split user list into username and host column, and allow sorting by header click. Also, add overlay icons for users with empty passwords, and added privilege objects. 2011-01-30 23:25:28 +00:00
59f6dbb3c4 Initialize child nodes after adding a privilege object to a user, so the parent checkbox checks all rather than only the first few visible child nodes. Regression introduced most probably in r3585. Fixes issue #2283. 2011-01-30 07:02:59 +00:00
6921e6e189 Make detection of disabled users more stable. See http://www.heidisql.com/forum.php?t=7433#p7442 2011-01-03 23:21:17 +00:00