• Joshua - Read the whole question. It clearly states that you invoke the approle. How do you do that? You use sp_setapprole, therefore you are setting everything up to be able to revert using sp_unsetapprole.

    Please, tell me if there is ANY other way to invoke an application role with out using sp_setapprole, as I am not aware of it.

    😎