Post reply

Execute permission

  • June 10, 2003 at 1:07 pm

    #160247

    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

  • June 10, 2003 at 1:37 pm

    #460641

    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

  • June 10, 2003 at 3:10 pm

    #460655

    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

  • June 10, 2003 at 3:10 pm

    #460653

    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