What are the challenges you face when working across database platforms? Take the survey
Options

Application Role missing in Grant Execution statement

hardingjahardingja Posts: 3
edited February 16, 2006 1:44PM in SQL Compare Previous Versions
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.

Thanks.

Comments

Sign In or Register to comment.