Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Administration  SQL Role keeps reappearing

Author  Topic  DCTFUK Starting Member 11 Posts Posted - 2014-12-01 : 04:58:57 I have a user group which I am having problems with. It has a role called databaseexclude which has an explicit deny for all schemas (I don't know if this is a standard role) Every time I remove the role from said users it reappears. It is stopping all those users from using RSSBus. It does the same if i remove the user from the role. I can remove this role from other user groups but just not this one. There doesn't seem to be any difference in the set up of this user to the others.