distal-attribute
distal-attribute
distal-attribute
distal-attribute

User manager and GRANT permissions

User, date Message
Racc Written by Racc
7 months ago
Category: General
2 posts since Thu, 06 Mar 14
Hello everyone, I hope someone will help me.

I am having problem with the users updating and changing tables. First, I have one client app that has user management and list of users, also I have HeidiSQL platform in which those users are listed. But, my Heidi username is not one of those in the list, so I have other username for accessing DB. My all users on the list are admins in that client that I need.

When I try to update something in the tables in DB, it returns errors like SQL Error 1142, command denied to user..

My question is how I change permissions, does it matter that my users are not the same? I guess my DB username is also admin.
How do I change permissions, privileges?

Thank you, I hope you get the question. I am pretty much new in this..
Racc
kalvaro Written by kalvaro
7 months ago
605 posts since Thu, 29 Nov 07
Tools/ User manager

I don't really understand the rest of the question. HeidiSQL does not have users of its own—it's nothing but a GUI client for another tool (MySLQ Server). And your application users are something you have designed—that's totally unrelated.
Racc Written by Racc
7 months ago
2 posts since Thu, 06 Mar 14
Thank you for reply.

When I go to Tools and User manager, it also gives me error, SQL Error 1227, again about privileges.

So, there is some other problem...
 

Please login to leave a reply, or register at first.