Hi Alvin,

The user DB access rights are stored in DB itself. After you restore DB from other source yiou've to give rights to user again.


>Hello,
>
>I am having an issue with a user login that I create in my SQL Server.
>
>DB4 has user A_User
>DB5 has user A_User
>
>I have created A_User under the security tab in SQL Server. I give A_User
>dbo rights to DB4 and DB5.
>The problem occurs when I restore DB4 and DB5 from another source..I notice that A_User does not have rights to access DB4 or DB5.
>
>I am not really clear on why or how to resolve this.
>
>Hope I wasnt too confusing.
>
>Thanks,
>
>