January 22, 2009 at 2:47 pm
Hi....I am executing following command to give grant permission to exec the stored proc to a user ..
GRANT EXEC ON dbo.plcStoredProc TO rptsqluser
which works fine....
But when I tried to execute this command on domain user
GRANT EXEC ON dbo.plcStoredProc to Domain\rptsqluser1
It gives me the error like incorrect syntax near '\'. so, can't we execute this command on domain users?? or do we have any other command??
Please let me know....
Thanks a lot...
January 22, 2009 at 2:52 pm
The username needs to be in [brackets] like this:
GRANT EXEC ON dbo.plcStoredProc to [Domain\rptsqluser1]
Hope this helps,
Greg
January 22, 2009 at 2:57 pm
yes....what a silly thing...
Alrite ...Thanks a lot for the quick reply...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply