June 24, 2008 at 9:14 am
Hello all,
I had the need to give alter permission on a stored procedure to a NT user. The only way I could do it was to give add the user to ddl_admin role.I know that this will give access to modify any data in the Db. IS there any better of doing this?
June 24, 2008 at 10:18 am
What happened when you tried:
Grant ALTER on storedprocedure to user?
Greg
June 24, 2008 at 11:15 am
I think thts only possible with 2005.
In 2000 as per books online:
ALTER PROCEDURE permissions default to members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and the owner of the procedure, and are not transferable.
Manu
June 24, 2008 at 1:22 pm
Yes that was the reason I added the user to ddl_admin.
The alter proc does not work
June 24, 2008 at 2:03 pm
I guess I should pay attention to which forum I'm in. Sorry about that.
Greg
July 3, 2008 at 2:46 am
I guess if you don't want to have the user access to other objects, better let your user create or alter the SP in his/her local server, say MSDE or your development database then let him/her provide you the alter script and let you execute it for him/her in your database.
just my 2 cents...
:-):cool:
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply