Bug #28062 | MyODBC 3/ ADO record set status - adRecPermissionDenied not working correctly | ||
---|---|---|---|
Submitted: | 24 Apr 2007 2:09 | Modified: | 13 Mar 2008 16:05 |
Reporter: | Erica Moss | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | Connector / ODBC | Severity: | S3 (Non-critical) |
Version: | 3.51.22 / 5.1.1 / 5.2.2 | OS: | Windows (xp sp 2) |
Assigned to: | Assigned Account | CPU Architecture: | Any |
Tags: | odbc51_postga |
[24 Apr 2007 2:09]
Erica Moss
[22 Oct 2007 14:39]
Susanne Ebrecht
Bug #28063 is a duplicate of this bug here.
[14 Dec 2007 9:01]
Erica Moss
Retested against MyODBC 5.51.22 and also 5.1.1 Problem is still present
[31 Jan 2008 19:33]
Tonci Grgin
As the server doesn't provide us with any information to be able to indicate that the user doesn't have update/insert/delete permissions on a particular result set this is almost impossible to fix. It's even hard to figure that out for a table without actually trying to insert/update/delete...
[6 Feb 2008 8:20]
Tonci Grgin
I must revert my ruling after making test: --<cut>-- +----+--------------------+------+ | ID | Name | File | +----+--------------------+------+ | 1 | blah | NULL | | 2 | blahblahblah | NULL | --<cut>-- mysql> update tst1 set Name = "tst again" where ID = 2; ERROR 1142 (42000): UPDATE command denied to user 'bug28062'@'localhost' for table 'tst1' #Error: 1142 SQLSTATE: 42000 (ER_TABLEACCESS_DENIED_ERROR) Message: %s command denied to user '%s'@'%s' for table '%s' Seemingly it is possible to track this and set proper recordset status. Jim?
[29 Feb 2008 21:20]
Jim Winstead
Set correct SQLSTATE for permission errors (no test case)
Attachment: bug28062.diff (text/plain), 913 bytes.
[13 Mar 2008 16:05]
Jim Winstead
Lawrin offered to take this over.
[3 Dec 2010 4:19]
Bogdan Degtyariov
Lawrin, you have the patch for this bug. Do you think it is still incomplete?