Testing login permissions

May 2, 2013 at 7:26 PM
I need to write tests to validate the permissions for various application logins. I'm planning on using the EXECUTE AS LOGIN = 'ApplicationLogin'; and REVERT statements in the tests. Is that the best way to tackle this problem? Any advice on how best to test permissions?