database permission and the asp.net provider model

database permission and the asp.net provider model

Postby 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?
KW
 
Posts: 123
Joined: Tue 19 Feb 2008 19:12

Postby 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.
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL