June 4, 2013 at 9:31 am
One Employee have been asked to Create a User defined Role named (ReadOnlyXYZ)
then create individual 90 login account :w00t:with read only access to a Specific Database..:w00t:
can anyone help in automating this??
is their any easy process for it...
************************************
Every Dog has a Tail !!!!! :-D
June 4, 2013 at 11:06 am
If you can get the 90 logins into a table, you could write dynamic SQL to print the needed T-SQL statements. Another way is if they are in Excel, write a formula in another column. (="CREATE USER..."). That's what I usually do with this type of scenario. Then clean up the table after you're complete.
June 4, 2013 at 11:12 am
I'd take a similar approach. They're going to provide you with a list of users somehow, so try to use that to generate the SQL you need to get the job done. When you think about it, 90 isn't terrible.
June 5, 2013 at 4:13 am
Assuming these are Windows authenticated logins rather than SQL autenticated wouldn't it be better to add them all to a security group in AD and just add the security group to the role rather than all the individual logins.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply