How to scripts object permission for user has in sql2005

Hi,
Is there anyway I can check what specific permissions user have for all objects in database ? I can use sp_helprotect to view the permission for a user but how could I generate a scripts to create the permissions ? I have around 100 tables with multi layer of permissions which I need to deploy in new server and db, db restore and generate sql task script did not generate this script :(
motioneyeAsked:
Who is Participating?
 
lozzamooreConnect With a Mentor Commented:
I've used this before and it got me most of the way there:

http://vyaskn.tripod.com/scripting_permissions_in_sql_server_2005.htm

Regards,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.