July 6, 2016 at 9:11 am
Hi All,
Today we have changed the collation of the server by rebuilding the system databases.
Before rebuild we have detached the user database and after rebuild we have attached them.
The customer is saying he is missing some permissions on some objects in databases.
Does changing of collation at server level causes this kind of issues.
How to reapply the permissions.
July 6, 2016 at 9:18 am
No, not as far as I know. What permissions is he missing? How did you do the attach and reattach of the databases? What did you change the collation from and to? Are you aware that you may get collation conflict errors now, especially if your application code creates temp tables and JOINs or UNIONs them to objects in your database?
John
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply