Grant execute rights on views

• Vera-428803

  SSCrazy

  Points: 2439

  More actions

  April 22, 2009 at 7:31 am

  #202399

  I have user A who creates views.

  User B has the right to execute those views.

  How can I grant user B the right to execute the views of user A without having to create them manually every time user A creates a new view.

  I'm working on SQL server 2000 with SP 4.

  My gut feeling tells me I'm overlooking something simple.

  Thanks,

  Vera

• Roy Ernest

  SSC-Dedicated

  Points: 38780

  More actions

  May 18, 2009 at 1:46 pm

  #996607

  You could give a fixed role like db_datareader but the only issue is that they get Select permission for tables as well.

  -Roy