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,

Alvin