Hi,

I'm trying to write a script to grant privileges to a user (we are trying to allow Windows Authentication in our application).

Previously, we used the following syntax:

grant select, insert, delete, update on area to mattuser

Where mattuser is a valid sql server user.

However, we want to do something like the following:

grant select, insert, delete, update on area to MATT2000\IUSR_MATT2000

Where IUSR_MATT2000 is a valid user on computer MATT2000.

We get an error when we try to run this script as follows:

Incorrect syntax near '\'

How do we grant permissions for this user, other than doing it manually?

Regards.

Matt.