December 2, 2010 at 2:40 am
I have bunch of user who has db_reader & db_writeer rights on database. For some reason , they need to modify the stored procs in the database so I gave them ALTER rights on stored procs required.
GRANT VIEW DEFINITION ON dbo.usp_test TO [domain\User]
GRANT ALTER ON dbo.usp_test TO [domain\User]
But still they are not able to modify the stored proc. Please help....
Thanks in advance.
Abhijit - http://abhijitmore.wordpress.com
December 2, 2010 at 4:16 am
Got the answer.... 🙂
Abhijit - http://abhijitmore.wordpress.com
June 14, 2011 at 12:45 am
what's the answer?
i also find this error :
Msg 3701, Level 11, State 5, Line 1
Cannot drop the table 'exported_ac_001', because it does not exist or you do not have permission.
what i will do to solve this error?
June 14, 2011 at 2:45 am
what permission level do you have???
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply