I have a MS SQL Server 2008 here at work with two backends in question. One is the HR DB and the second is the Training DB. We use Active Directory Groups for granting permissions. I do use Datareader/Datawriter Mappings, if you have a better solution, feel free to enlighten me. I did it because it was easy, and I am not a True DBA.
DB_Training Group has Datareader/Datawriter access to only the Training DB.
DB_HR Group has Datareader/Datawriter access to only the HR DB.
I have a Training DB that I would like for it to pull Employee Names, Departments, Jobs, and etc... However, I do not want to grant them full access to the HR DB, so after some googling, I came up with the idea of using a View.
I created a View in the Training DB that grabs the needed info from the HR DB. This is working great, for the DBA... Before I turn this loose, I want to know if someone from the Training Group will be able to access the needed info, or are they going to get denied because they are not part of the HR Group?
Thank you, and as always, its much appreciated.
Chris
DB_Training Group has Datareader/Datawriter access to only the Training DB.
DB_HR Group has Datareader/Datawriter access to only the HR DB.
I have a Training DB that I would like for it to pull Employee Names, Departments, Jobs, and etc... However, I do not want to grant them full access to the HR DB, so after some googling, I came up with the idea of using a View.
I created a View in the Training DB that grabs the needed info from the HR DB. This is working great, for the DBA... Before I turn this loose, I want to know if someone from the Training Group will be able to access the needed info, or are they going to get denied because they are not part of the HR Group?
Thank you, and as always, its much appreciated.
Chris
Last edited:
