database permission and the provider model

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Posts: 124
Joined: Tue 19 Feb 2008 19:12

database permission and the provider model

Post by KW » Wed 04 Feb 2009 23:21

What are the minium permissions required to use the mysql membership providers? That is, what grants do I need to give a mysql user to be able to fully use the providers?

Devart Team
Posts: 8083
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 05 Feb 2009 12:56

We think that it will be enough for a MySQL user to have the Insert, Delete and Select privileges when accessing our schema to work with MySQL Membership Providers. But we didn't investigate the privilege issue.

Keep in mind that web applications are usually run in a partially trusted environment. Here are the permissions required by dotConnect for MySQL:
  • in Direct mode - medium trust plus SocketPermission;
  • in client mode - just medium trust permissions.

Post Reply