Sure.

I do not want to grant permissions on server directly to any users but there are some operations that I would like to allow users to perform without depending...

Thank you very much Steve. That helps me see more clearly why the idea of schema permissioning isn't so common.

If I may, a side question - if we're going...

Steve Jones - SSC Editor (9/12/2011)

---

I do know that's not always practical or possible, in which case I would still move with a role having the insert/select/update/delete permissions on objects....

Thanks, Jeff. Your reply makes me think I should add a bit of background:

The "users" are actually applications that need to have some ad-hoc querying capabilities for better or worse....

Just if anyone runs across this, this is worked.

Basically, spid -2 is the transaction manager used in SSIS, which as I indicated in OP had crashed and thus orphaned its...