Hi All,

I have backup my database and restore it in the other server (e.g. serverA transfer to serverB).
In my database (e.g. sample) the user (e.g. sqluser) have a permission in the database.
When I have restore it in serverB the permission of the sqluser was also included in the restored database.

My problem is when I reasign the permission for sqluser in the database, it wont allow me to do it because the user sqluser is already attach to the database.

What should I do to reassign the permission to the sqluser?


Any help should be greatly appreciated.


TIA,

Rene