how do I see what permission and object has...

• tjaybelt

  SSCrazy

  Points: 2604

  More actions

  March 15, 2004 at 10:37 am

  #161113

  I always use a template to create my db objects, and permission is assigned at the end.  Usually its grant all to public.  I know this inspires some arguments.  But, i have a programmer that consistently skips the assignment.  Some of our users cannot get to his objects. 

  So, i just want a way to see what objects are assigned to what group.  Then I can fix the ones that are missing. 

  I don't want to bulk assign them all.  Just the ones that have missing assignments.

   

  Thanks.

• bp

  SSCarpal Tunnel

  Points: 4656

  More actions

  March 15, 2004 at 2:21 pm

  #498835

  to see what permissions an object has, use  

  sp_helprotect

  from BOL: Returns a report with information about user permissions for an object, or statement permissions, in the current database.

  HTH

  Billy