Posted by wackyphill on 03/24/06 14:51

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.

• Next in forum: generation of sql for an alter column etc
• Prev in forum: Help selecting an alias
• Thread view: Grant Win Acct Permission

[Reply to this message]