Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Security / September 2005

Tip: Looking for answers? Try searching our database.

Duplicate an existig SQL user login account

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John Williams - 26 Sep 2005 17:26 GMT
How does one create a copy of an existing SQL login account.  I have a
database that has a single login with everything setup.  I just want to be
able to copy the existing account to a new user so I can set a different
password.

Thanks!
Tony Sebion - 26 Sep 2005 19:15 GMT
You might be able to get what you want by "Generating SQL Script" from
the right-click context menu on the database you want to add the user
to.  Place the checkmarks on the first tab to create all types of
objects, uncheck the options to create the CREATE and DROP statements on
the second tab, and go to the 3rd tab and check "Script object-level
permissions".

When you build the script, it should include commands that grant the
permissions to the current account that holds the permissions.  You will
have to manually pick through the script commands to find the
appropriate ones and change the name of the user to replace the old
user's username with the new one to build an entirely new script.

While not the answer you're looking for, I think you should consider
creating one or more roles configured to grant permissions that match
the account that is configured properly now, then create the new account
and add the both user accounts to the role you created.

Good luck,
Tony Sebion

> How does one create a copy of an existing SQL login account.  I have a
> database that has a single login with everything setup.  I just want to be
> able to copy the existing account to a new user so I can set a different
> password.
>
> Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.