11/10/2009 1725 views

I have an application, request is given below:

"Application authenticates to the SQL Server database via Windows Authentication. User must be included in the Group that has been granted database access permission. User should have READ-WRITE access to the database and the rlsproc_role in their profile."

In which group user should be added, group name is not mentioned.

My understanding is,

1) we will need to ask client for that group name.
2) How can we add particular user to another group, through our package? will we need to use group policy?

Please correct me if I am wrong, because nobody is there to guide me for the same.

0 Comments   [ + ] Show comments


Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

All Answers

I'm thinking this is something for your DBAs. Read access to the SQL database and what profile a user gets is not something you should bother with client-side.
When you test your package you'll have to make sure your testuser is known and has the correct profile in the database though, so go talk to the DB admins in advance [;)]

Answered 11/10/2009 by: pjgeutjens
Red Belt

Think: how will your package cope if (sorry, when) the client changes the group name? On the same note, forget about adding users to the group. Leave that activity to the client.
Answered 11/10/2009 by: VBScab
Red Belt

I was confused totally.
Thanks a lot guys... [:)]
Answered 11/10/2009 by: abking99
Second Degree Blue Belt