• Schemas do not own things, but I know what you mean.

    In that case you can look into certificate signing or EXECUTE AS. I would go for certificate signing, it's a bit cleaner and you do not need to deal with impersonation.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato