I amigo, i have a request for you.
i have a C# Solution with a Database Project inside it. In the DataBase project i defined a Role like this:

GO
CREATE ROLE db\_KteUsers
GO
DENY EXECUTE TO db\_KteUsers
GO
GRANT SELECT TO db\_KteUsers
GO
GRANT SELECT, INSERT, UPDATE, DELETE ON SCHEMA :: [cfg] TO db\_KteUsers

When deployed if i granted more things to the role, i would like that when i publish the db again this newly added permissions are revoked. something like, when i publish the db reset the role as i describe it in the project.
Can you help me with this?
user