This recipe shows how to create a database user by using PowerShell and SMO.
If you haven't already done so in the Creating a login recipe, create a SQL login called eric. Alternatively, feel free to substitute this with a login that already exists in your system.
In our recipe, we will use a login called eric, which we will map to a user called eric in the AdventureWorks2014 database. Here's the T-SQL equivalent of what we are trying to accomplish:
USE [AdventureWorks2014] GO CREATE USER [eric] FOR LOGIN [eric]
Here are the steps to create a database user:
Open PowerShell ISE as an administrator.
Import the
SQLPSmodule and create a new SMO Server Object as follows:#import SQL Server module Import-Module SQLPS -DisableNameChecking #replace this with your instance name $instanceName = "localhost" $server = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $instanceName
Add the following script and run:
$loginName ...