Post reply

GRANT EXECUTE

  • May 16, 2012 at 3:50 am

    #256519

    Hi all

    I ran a grant execute to [Domain\ID] at a database scope to grant the account the ability to execute SPs . I then thought I would look at the properties of the proc and in the permissions screen I was expecting to see the account with Execute granted, but it is not there.

    Why is this?

    Thanks

  • May 16, 2012 at 3:57 am

    #1488268

    What is the exact command that you ran?

    John

  • May 16, 2012 at 3:58 am

    #1488269

    This is down to the scope and inheritance, as you granted the permissions at the database level not the procedure level, so you wont see it at the lowel level as you have not implicitly granted access to that particular proc.

  • May 16, 2012 at 3:59 am

    #1488270

    Ahhh ok - thanks

Viewing 4 posts - 1 through 4 (of 4 total)

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