Matt,
Enclouse the user name in the square brackets
grant select, insert, delete, update on area to [MATT2000\IUSR_MATT2000]
>
>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?
--sb--