域\用户GRANT语法 [英] GRANT syntax for domain\user

问题描述

我想给访问活动目录用户只有一个特定的表。我希望他们能够插入，更新，删除等，但仅适用于该表。我知道这个命令：

  GRANT插入，tablename上选择用户
 

但我想不出如何让域\用户的工作语法，明智的。我想：

  GRANT插入，tablename上选择域\用户
 

但我得到：

  

消息102，级别15，状态1
附近有语法错误'\'。

解决方案

假定你已经创建了与AD登录名关联这个数据库中的用户，如：

  CREATE LOGIN [域\用户] FROM WINDOWS;
走
USE your_database;
走
CREATE USER [域\用户] FROM登录[域\用户]
走
 

然后你只需要遵循相同的语法。因为 \ 不是一个标识符一个标准的字符，你需要逃脱名为 [方括号] ：

  GRANT SELECT，INSERT，UPDATE，DELETE ON dbo.Tablename TO [域\用户]
 

I'm trying to give access to an active directory user to only one specific table. I want them to be able to insert, update, delete, etc. but only for that table. I know this command:

GRANT Insert, Select on Tablename to user

But I can't figure out how to get "domain\user" to work syntax-wise. I tried:

GRANT Insert, Select on Tablename to domain\user

But I get:

Msg 102, Level 15, State 1
Incorrect syntax near '\'.

解决方案

Assuming you have created a user in this database associated with the AD login, e.g.

CREATE LOGIN [domain\user] FROM WINDOWS;
GO
USE your_database;
GO
CREATE USER [domain\user] FROM LOGIN [domain\user];
GO

Then you merely have to follow the same syntax. Because \ is not a standard character for an identifier, you need to escape the name with [square brackets]:

GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.Tablename TO [domain\user];

这篇关于域\用户GRANT语法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！