User Rights - Database Security I am having following scenarios and i am having some issues and some questions.


We have a DB Server on which we have some databases in these 2(two databases) are for my users.
Now i have created 2 windows group login A &amp; B, A is the user which can only read data from 2 DB's, and B is the user which can do a restore to DB's.
Now what i like to know, is this possible to restrict user B to have restore DB rights only on 2 databases(i have many on my server)
Another problem i am facing is when i am restoring DB from user A than all rights assigned to user B from that specific DB are not there, so how can i always keep my user rights same for every DB.


I am using SQL Server 2008. Thanks in Advance.
To move logins and users from the source server, I use the following solution. This script helps completelly transfer logins with user permissions  (see description on the top of the script how t use it and to specify the databases and logins).