June 10, 2003 at 1:07 pm
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
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
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
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