Home Forums SQL Server 2005 Administering 1 sp out of 4 not executing even though user has execute permissions on all 4 RE: 1 sp out of 4 not executing even though user has execute permissions on all 4

  • January 7, 2013 at 11:31 am

    #1574448

    All users have connect permissions only

    Role has execute permission - and user is part of role - this is how they are granted execute permissions -via this role

    Role has deny execute on 1 sp only - which isn't used in this scenario

    there are no permissions against tables directly