February 7, 2008 at 6:49 am
Hi there
I am quite new to SQL 2005 and am stuck with a particular task .
The requirements of the task is written below :
[ I want a script that creates all logins, users and roles for a particular database. I want the object level permissions associated with the users or the roles, in other words I want to include the necessary SELECT, UPDATE, INSERT, DELETE, and EXECUTE privileges that each user or role has upon the objects (tables, views, procedures, functions etc.) within the database . ]
This script has to be dynamic ( be used over and over )
Can someone please help me with this or give me a few pointers how to achieve this ? :ermm:
Thanx in advance
February 7, 2008 at 7:30 am
Honestly I tried creating a script like that at one point. Its not easy .. at all. I ended up going with a 3rd party freeware application called SQLPermissions. It does exactly what you are looking for. RedGate may have something similar but I havn't seen it before.
Kenneth
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
February 8, 2008 at 1:14 am
Hehehe yeah I know ! Talk about throwing a newbie in the deep end of the pool ! 😀
I attempted to make the script , but am unsure if this is what the guy wants . He gave me this task to practice my T-SQL and told me if I am stuck that he will give me a script for me to learn from . Ironically , he is on leave today and won't be back until March !
I'll take a look at that application you mentioned , maybe I can use it for future reference .
Thank you for taking the time to answer my question , it is VERY much appreciated .
I shall not hesitate to come back here and ask the experts like yourself if I have any future questions .
Cheers !
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply