Grant Win Acct Permission

I'd like to grant a WIndows account permission to connect to a db and
exec stored procedures. But am having trouble.

I want this type of effect but can't get the syntax correct:

USE MyDB
GO
CREATE USER 127.0.0.1\ASPNET   --ASPNET Account for current machine
GO

GRANT EXECUTE ON AllStoredPRocs TO 127.0.0.1\ASPNET

How is this done in a t-sql script?

Thanks for any help.

(wackyphill@yahoo.com)  writes:
> I'd like to grant a WIndows account permission to connect to a db and
> exec stored procedures. But am having trouble.
>
> I want this type of effect but can't get the syntax correct:
>
> USE MyDB
> GO
> CREATE USER 127.0.0.1\ASPNET   --ASPNET Account for current machine
> GO
>
> GRANT EXECUTE ON AllStoredPRocs TO 127.0.0.1\ASPNET
>
> How is this done in a t-sql script?


Since 127.0.0.1\ASPNET is one identifier as far SQL Server is concerned,
you need to put it brackets:  [127.0.0.1\ASPNET]. Then whether that
actually works is another matter. You should probably use machine name
rather than 127.0.0.1.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx