This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
Summary: | org.netbeans.api.db.explorer.DatabaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'travel'@'d-espb04-127-12.Russia.Sun.COM' for table 'user' | ||
---|---|---|---|
Product: | db | Reporter: | Roman Mostyka <romanmostyka> |
Component: | Code | Assignee: | David Vancouvering <davidvc> |
Status: | VERIFIED FIXED | ||
Severity: | blocker | ||
Priority: | P3 | ||
Version: | 6.x | ||
Hardware: | All | ||
OS: | All | ||
URL: | http://statistics.netbeans.org/exceptions/detail.do?id=32991 | ||
Issue Type: | DEFECT | Exception Reporter: | 32991 |
Attachments: | stacktrace |
Description
Roman Mostyka
2008-03-03 09:38:47 UTC
Created attachment 57647 [details]
stacktrace
This exception is because you are not logged in as a user that has privileges to select system tables. I suppose what I could do is try to detect if the user has the right privileges before trying to select the list of current MySQL users and then just not show that drop-down of users. If the user doesn't have select privileges on the system tables, they probably don't have privileges to create a database either. So maybe this is an enhancement request to check privileges before making this choice available on the MySQL node. What do you think? I think it's good idea to check if user has right privileges. Now it looks like real bug, because after exception "Create MySQL Database" dialog appears anyway. OK, I concur I still can reproduce this issue with build: Product Version: NetBeans IDE Dev (Build 080306) Java: 1.6.0_03; Java HotSpot(TM) Client VM 1.6.0_03-b05 System: Windows XP version 5.1 running on x86; Cp1251; ru_RU (nb) I built IDE from fresh sources and successfully reproduced this issue. Please, check if your changes are in trunk. If you're sure that this issue is fixed make it FIXED again, but I built IDE from fresh sources after you push. My apologies, I closed the wrong bug, thanks very much for spending the time to verify and catching this. Verified with build 080312. |