Can exec permissions (e.g. on a SP) be granted to a role in SQL Server 2008, so that all role members then have the permission; and if the 2008 database were backed up and restored into SQL Server 2012, and a 2012 user were added to the (restored) role, would that 2012 user receive those permissions too?
P.S. I am granting exec permission to individual SPs and functions. So I did this in 2008:
grant exec on sp1 to myrole; grant exec on sp2 to myrole; grant exec on sp3 to myrole; grant exec on sp4 to myrole; . . . grant exec on sp150 to myrole;
I selected all 150 lines of text in the edit window of SSMS and clicked the Execute button. Did the same thing with the tables and that worked--they all carried over to 2012-- but the exec grants did not carry over to 2012 for some reason.