Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

script to create login ID's From the contents of a table Expand / Collapse
Author
Message
Posted Thursday, August 16, 2012 5:50 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, November 25, 2012 5:50 PM
Points: 40, Visits: 66
I need to write a script that creates will create login ID's based on the contents of a table. For the purpose here I will call the table newLogins, and I need to perform 3 actions for each row in this table using dynamic SQL. First I need to create a login with a temporary password based on the first four letters of the login name followed by 9999, secondly set the default database (for this I will use AP) and three I need to create a user for the login with the same name as the login and assign the users to the 'PaymentEntry' role.

I could really use some help here I am new to sql and absolutely brand new to Dyanmic SQL!

Create Table NewLogins
(LoginName varchar(128))

Insert NewLogins
Values ('BBrown'), ('CChaplin'), ('DDyer'), ('EEbbers')
Post #1346297
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse