SQL Server 权限管理

1. 查询数据库所有者

SELECT name AS dbname, SUSER_SNAME(owner_sid) AS owner FROM sys.databases;

2. 修改数据库所有者

USE $DBName$;
GO

EXEC sys.sp_changedbowner @loginame = '$sa$';

3. 授予用户权限

USE $DBName$;
GO

GRANT $SELECT$ ON $dbo$.$TblName$ TO $UserName$;

4. 添加登录名并授予 sysadmin 角色

CREATE LOGIN $LoginName$ WITH PASSWORD = '$Password$', CHECK_POLICY = OFF; -- 不强制实施密码策略

ALTER SERVER ROLE sysadmin ADD MEMBER $LoginName$;