Request to add user in database group


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

Answers (3)

Posted by: pjgeutjens 13 years ago
Red Belt
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 [;)]

Posted by: anonymous_9363 13 years ago
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.
Posted by: abking99 13 years ago
Second Degree Blue Belt
I was confused totally.
Thanks a lot guys... [:)]
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ