database permission and the asp.net provider model
database permission and the asp.net provider model
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?
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:
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.