GRANT EXECUTE not working

[ben h]

How do I correct this error??

GRANT EXECUTE ON procMyProc TO NEVUS\IUSR_NEVUS

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '\'.

This is the IIS web account for my machine, and the database user name
and login name are the same. I can't change the login name, can I?

I'm trying to script privileges to a bunch of user stored procs to the
web user account. Maybe there's another way?

Ben

[Aaron [SQL Server MVP]]

\ is not a valid character in an identifier, so you need to surround the
username with [].

GRANT EXEC ON procMyProc TO [NEVUS\IUSR_NEVUS]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)





"ben h" <none@noone.com.invalid> wrote in message
news:%23eH6B0XaEHA.384@TK2MSFTNGP10.phx.gbl...

> How do I correct this error??
>
> GRANT EXECUTE ON procMyProc TO NEVUS\IUSR_NEVUS
>
> Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near '\'.
>
> This is the IIS web account for my machine, and the database user name and
> login name are the same. I can't change the login name, can I?
>
> I'm trying to script privileges to a bunch of user stored procs to the web
> user account. Maybe there's another way?
>
> Ben