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 & 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.