Solved

How to scripts object permission for user has in sql2005

Posted on 2011-03-15
1
288 Views
Last Modified: 2012-05-11
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 :(
0
Comment
Question by:motioneye
1 Comment
 
LVL 7

Accepted Solution

by:
lozzamoore earned 500 total points
ID: 35139058
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

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now