How to exclude permissions in SQL Compare 11?

Team,

I have a ton of objects which are being flagged as deltas simply because of the listings under

-- Permissions

GRANT CONTROL ON TYPE:: [dbo].[typAccountLockInfo] TO [SQLProdReadOnly]
GRANT VIEW DEFINITION ON TYPE:: [dbo].[typAccountLockInfo] TO [SQLProdReadOnly]
GRANT REFERENCES ON TYPE:: [dbo].[typAccountLockInfo] TO [SQLProdReadOnly]
GRANT CONTROL ON TYPE:: [dbo].[typAccountLockInfo] TO [SQLProdReadOnly]
GRANT VIEW DEFINITION ON TYPE:: [dbo].[typAccountLockInfo] TO [SQLProdReadOnly]
GRANT REFERENCES ON TYPE:: [dbo].[typAccountLockInfo] TO [SQLProdReadOnly]

Can I shut this off?
Thanks,
Ozzie

Ozzie February 24, 2015 16:52

Comments

2 comments

I think the Ignore Permissions option ( http://documentation.red-gate.com/displ ... ermissions ) might do what you want

Mark J February 25, 2015 06:06

0
TY - totally did the trick - somehow that had gotten reset and I couldn't find it.

Doug

Ozzie February 25, 2015 07:38

0

Add comment

Please sign in to leave a comment.

How can we help you today?

How to exclude permissions in SQL Compare 11?

Comments

Add comment