Home Forums Article Discussions Article Discussions by Author Discuss content posted by W Louw Permission scripting over all databases RE: Permission scripting over all databases
Sailor
SSCertifiable
Points: 5239
More actions
December 13, 2012 at 9:10 am
#1568357
For the new user, I'd it to generate a create user statement:
USE [dbname]
GO
CREATE USER [mynewuser] FOR LOGIN [domain\firstname.lastname]
Where mynewuser is paramater 1 and domain\firstname.lastname is second parameter.