Page 1 of 1
database permission and the asp.net provider model
Posted: Wed 04 Feb 2009 23:21
by KW
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?
Posted: Thu 05 Feb 2009 12:56
by Shalex
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.