I believe granting execute gets your basic CRUD, but TRUNCATE is more of an admin instruction, so it requires explicit granting rather than implied. I'm not 100% sure though. I've never used TRUNCATE in production code before.
-tg
|
Results 1 to 4 of 4
Thread: Table permissions in SPROCSThreaded View
|
Click Here to Expand Forum to Full Width |