Minimum permissions for alter table
Posted on 2011-10-13
I have a web based .net 4 app which allows admin users to issue commands which add columns to tables.
When I try "alter table" with the usual default app permissions they fail.
So I grant "alter" to the user on the table, then it fails with a different error message - "sqltransaction has completed it is no longer usable"
I tried changing the users default schema to be "dbo", which is where the tables are, but same problem.
But if I make the user a member of the sysadmins role, it works fine.
Any ideas what the minimum permissions are ? I don't really want to make customer's sysadmin users!
EDIT: This is running on Sql 2008 R2. Web edn..