db_owner

Question

db_owner

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Easiest way to manage this, create an AD group for the application, put all users of the app into that group, and then grant execute permissions on the stored proces to that AD group. As users come and go, all you have to do is add/remove users from the AD group.

rsheppick SSC Rookie Points: 37 More actions · Answer 2

Lynn Pettis (6/30/2009)
Easiest way to manage this, create an AD group for the application, put all users of the app into that group, and then grant execute permissions on the stored proces to that AD group. As users come and go, all you have to do is add/remove users from the AD group.

This is what I was wanting to do, however, how do I grant the execute to the groupitself not a user.

rsheppick SSC Rookie Points: 37 More actions · Answer 3

what i decided to do is create a role called db_executor then grant execute to db_executor.

Problem solved.