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

Not comparing GRANT REFERENCES on CONTRACT

dunosdunos Posts: 8
edited June 18, 2010 8:38AM in SQL Compare Previous Versions
Hi,

I have two databases created from the same script file. Against one of the databases I execute the following to set up query notification:

GRANT CREATE PROCEDURE to [sql_dependency_starter]
GRANT CREATE QUEUE to [sql_dependency_starter]
GRANT CREATE SERVICE to [sql_dependency_starter]
GRANT REFERENCES on
CONTRACT::[http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification]
to [sql_dependency_starter]
GRANT VIEW DEFINITION TO [sql_dependency_starter]

When I compare the two databases SQL Compare 8.2.0.16 notices there are differences in the role permissions. SQL Compare comes back with:

GRANT CREATE PROCEDURE TO [sql_dependency_starter]
GRANT CREATE QUEUE TO [sql_dependency_starter]
GRANT CREATE SERVICE TO [sql_dependency_starter]
GRANT VIEW DEFINITION TO [sql_dependency_starter]

What happened to the GRANT REFERENCES on CONTRACT?

Thanks

Comments

Sign In or Register to comment.