Post reply

unable to view all permissions on SPs

  • December 4, 2006 at 4:00 pm

    #171490

    Greetings all - in management studio i have users who are able to see some but not ALL permissions on some stored procedures.  Any idea why this is and how to fix this?

    Thank you muchly!

  • December 4, 2006 at 9:19 pm

    #675710

    Can you explain a bit more what you mean? Do you mean they can see say EXECUTE but not CREATE?

     

    K. Brian Kelley
    @kbriankelley

  • December 5, 2006 at 8:15 am

    #675868

    Hi there!  Ok - to clarify, when our developer right clicks into a stored procedure's properties and goes into the permissions, there is a list of users/roles who have execute on that procedure.  Let's say if there are 5 users/roles who have execute on that procedure for the developer it doesn't list them all.  Any explanation? 

Viewing 3 posts - 1 through 2 (of 2 total)

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