Execute permission

  • Is there a way to grant a user execute permission on all stored procedures created now and those created later. Basically I want inherited execute permision for a given user.

    John Zacharkan


    John Zacharkan

  • You can use user defined role and add members to the role.

    Whatever permission the role is given will be inherited by members.

    But every time new objects are added, you need to adjust permission on the Role.

    In other word permission has to be set explicitly on newly created objects @ role level.

    MW


    MW

  • yeah, I saw that too.

    I was just looking for the same inherited right that sa has to execute.

    Thanks for the thought.

    John Zacharkan


    John Zacharkan

  • yeah, I saw that too.

    I was just looking for the same inherited right that sa has to execute.

    Thanks for the thought.

    John Zacharkan


    John Zacharkan

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

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