Minimum required permissions for SQL user?
Posted: Thu Sep 17, 2009 8:05 pm
So lately I've been wanting to lock down the server a bit more and am wondering what the minimum permissions needed would be for an SQL user for the server?
These are obviously needed:
Select
Insert
Update
Delete (idfactory needs that)
Create
Now beyond those, I'm not 100% sure.
Drop? Reload? Shutdown? Process? File? Grant? References? Index? Alter? And so on and so on with the rest of the permissions.
This is just for the user account that the server would use, nothing more.
These are obviously needed:
Select
Insert
Update
Delete (idfactory needs that)
Create
Now beyond those, I'm not 100% sure.
Drop? Reload? Shutdown? Process? File? Grant? References? Index? Alter? And so on and so on with the rest of the permissions.

This is just for the user account that the server would use, nothing more.
