?
Solved

Is there any way to "clone" a SQL user account?

Posted on 2010-09-14
3
Medium Priority
?
313 Views
Last Modified: 2012-05-10
Hello,

I have multiple SQL accounts I need to configure exactly the same.  If I do them one at a time, I have to go through multiple places to setup the security and user roles, schemas etc.  Is there any way to clone a user?

The only thing that would be different for each user is their default schema, password and username.

SQL 2008 x64

Thanks!
0
Comment
Question by:caw01
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 30

Expert Comment

by:Rich Weissler
ID: 33675429
If it were me, I'd script the first one with CREATE LOGIN, GRANT, etc...
I suspect because that facility is available, there hasn't been created a way in the GUI to clone a user.
0
 

Author Comment

by:caw01
ID: 33676147
Alright...  Not a SQL guy so I will have to figure that one out...  Unless someone can help me write a script.  
0
 
LVL 30

Accepted Solution

by:
Rich Weissler earned 2000 total points
ID: 33676223
If I remember the interface for SQL 2008 Management Studio, there is script button in the upper left corner of the create logon window that might help get you started... it'll at least show you what commands it is using the create your user.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

752 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