How do i grant a user to exec a stored procedure which executes DENY table permissions inside the proc but hte user is nto a sysadmin or security admin to do so but i would like to give the user to exec the proc, any options?
I tried "EXECUTE AS" User but its not working.