CODEWITHSUNDEEP
sqlsql-serversql-server-2008-r2
hermann
hermann

Reputation: 6295

Escaping backslash in SQL Server GRANT

GRANT SELECT ON tableName TO something\user_name

Unfortunately, when I execute this in SQL Server 2008 R2 I get an Incorrect syntax near '\'. error.

Is there a way to escape a backslash, or what should I do?

Upvotes: 6

Views: 4133

Answers (1)

Andomar
Andomar

Reputation: 238216

GRANT SELECT ON tableName TO [something\user_name]

Upvotes: 17

Related Questions