Renaming users is easy. Spreading the news about it is hard. Especially the SQL Server is ignorant about changes. All security tokens for an user or group is cached for Performance reasons. The only way to force an update is to drop the existing cache using:
DBCC FREESYSTEMCACHE ('TokenAndPermUserStore')
No comments:
Post a Comment