Powershell - 用户映射 SQL Server 2012 [英] Powershell - User Mapping SQL Server 2012
本文介绍了Powershell - 用户映射 SQL Server 2012的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试为不同的登录帐户编写用户映射脚本.我已经编写了创建用户和单个服务器角色的脚本,但我不知道如何使用 Powershell 设置用户映射,我还需要设置 Database Role members
,特别是 db_backupoperator
I am trying to script User Mapping for different Login accounts. I have scripted the creation of users and individual server roles, but I can't figure out how to set User Mapping with Powershell, I will also need to set the Database Role membership
, in Particular, db_backupoperator
有人知道如何用 Powershell 做到这一点吗?
Anyone know how to do this with Powershell?
推荐答案
假设您的登录名已创建
## Creating database user and assigning database role
#get variables
$instanceName = "yourInstance"
$loginName = "testLogin"
$dbUserName = "testUserName"
$databasename = "tempdb"
$roleName = "db_backupoperator"
$server = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $instanceName
#add a database mapping
$database = $server.Databases[$databasename]
$login = $server.Logins[$loginName]
if ($database.Users[$dbUserName])
{
$database.Users[$dbUserName].Drop()
}
$dbUser = New-Object `
-TypeName Microsoft.SqlServer.Management.Smo.User `
-ArgumentList $database, $dbUserName
$dbUser.Login = $loginName
$dbUser.Create()
#assign database role for a new user
$dbrole = $database.Roles[$roleName]
$dbrole.AddMember($dbUserName)
$dbrole.Alter
这篇关于Powershell - 用户映射 SQL Server 2012的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文