sqlserver修改连接服务器信息,SQLServer修改登陆账户信息

数据库引用

use testss;

go

--修改登陆账户属性

alter login testuser

with

password='1234',--default_database=database[,]

--default_language=language[,]

name=testuser,check_policy=on,check_expiration=on

--credential=credential_name [,]

--no credential[,]

--add credential credential_name[,]

--drop credential credential_name

--可以添加多个服务器角色

--创建服务器角色,服务器角色用于向用户授权服务器范围内的安全特权

--alter server role [bulkadmin] drop member [testuser];

--go

--alter server role [dbcreator] drop member [testuser];

--go

--alter server role [diskadmin] drop member [testuser];

--go

--alter server role [processadmin] drop member [testuser];

--go

--alter server role [securityadmin] drop member [testuser];

--go

--alter server role [serveradmin] dr