Does your developer by any chance have other permissions that would explicitly deny privileges in those schemas?

You can check pretty easily, make a new user and give them...

The answer is neither, you should have good requirements first.  Then an agreed upon design between any front and database developers that can be worked on collaboratively as issues come...

Hmm... there aren't read only schemas, do you mean read only permissions for a login/role?

But more importantly why are you not worried about SQL injection?  Do any of...

Deleting records does not automatically shrink the mdf file, you have to run a shrink operation to do that. Do you actually need to free up the disk space?

I have this requirement alot.  I use a pretty straight forward powershell script for it, you specify a file to wait for, the minimum age of the file(prevents picking up...

Is your requirement really only for exactly midnight?  The options above work for exactly midnight as in 2016-12-13 00:00:00.000, what about 2016-12-13 00:00:00.003?

If this is really just a temp table why do you need the identity on the temp table, just make it a plain int with no identity and you can...

If you mean the mdf file didn't shrink after rebuilding the indexes that is expected.  You should see free space in the DB if you look in SQL Server but...

You could also try running it with OPTION(MAXDOP 1) and see if you get any difference.