Application Role missing in Grant Execution statement
I'm comparing stored procedures in two SQL 2005 databases and all of the stored procedures are listed as different. The only difference is the Grant Execute on [store procedure name] to [Property]. Property is an application role in both databases and has been granted execution rights on all stored procedures in both databases. For Database A it shows: Grant Execute on [dbo].[spPrpCreate] to [Property] and for Database B it shows: Grant Execute on [dbo].[spPrpCreate] to . For some reason the application role [Property] isn't being scripted out and/or recognized in Database B.
0 · Share on Twitter