February 5, 2008 at 3:57 am
Hi Everybody,
We have to give CREATE, ALTER and EXEC permissions for only the SPs that needs to be created for a particular DB.
It's like we've got a user who isn't allowed to modify the existing SPs but has permission to create new ones and alter the ones which was created by them.
What's the way to do this?
Thanks,
Sayan
February 5, 2008 at 4:26 am
sayan ghosh (2/5/2008)
Hi Everybody,We have to give CREATE, ALTER and EXEC permissions for only the SPs that needs to be created for a particular DB.
It's like we've got a user who isn't allowed to modify the existing SPs but has permission to create new ones and alter the ones which was created by them.
What's the way to do this?
Thanks,
Sayan
Are these new procedures accessed by the user who creates them? You could create a default schema for these users, and allow them to create procedures in this schema only. (see CREATE SCHEMA, (this is on SQL Server 2005))
Regards,
Andras
February 6, 2008 at 2:28 am
Yes it is like that. Actually in our DB we have two primary users - the SA user and the NORMAL ones.
Now a group amongst the NORMAL ones are going to CREATE some SPs, and maybe ALTER only those which they created.
It's like if NORMAL has 3 members having ID nm1, nm2, nm3....and among them if nm2 and nm3 are only going to CREATE some SPs; then the CREATE/ALTER SP permission should only be given to nm2 and nm3 AND NOT the rest of the members of NORMAL user.
Yeah I reckon we can create a schema and give CREATE permissions to the NORMAL user, but how to give them to specific members?
Thanks,
Sayan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply