sqlserver 权限常用语句
时间: 2023-07-06 17:20:38 浏览: 50
以下是 SQL Server 常用的权限相关语句:
1. 创建数据库用户并授权:
```
CREATE LOGIN [username] WITH PASSWORD = 'password';
USE [database_name];
CREATE USER [username] FOR LOGIN [username];
GRANT SELECT, INSERT, UPDATE, DELETE ON [table_name] TO [username];
```
2. 授予数据库角色权限:
```
USE [database_name];
EXEC sp_addrolemember 'db_datareader', 'username';
EXEC sp_addrolemember 'db_datawriter', 'username';
```
3. 授予服务器角色权限:
```
USE [master];
EXEC sp_addsrvrolemember 'username', 'sysadmin';
```
4. 检查当前用户的权限:
```
SELECT * FROM fn_my_permissions(NULL, 'DATABASE');
SELECT * FROM fn_my_permissions(NULL, 'SERVER');
```
5. 检查指定用户的权限:
```
SELECT * FROM fn_my_permissions('username', 'DATABASE');
SELECT * FROM fn_my_permissions('username', 'SERVER');
```