Sql Server 2000 Grant Permissions to user with numeric ID problem

[ProntoMatt]

The statement below works just fine:
grant all on NEW_STORED_PROC to 'a99bcde';

A similar statement of
grant all on NEW_STORED_PROC to '038151';
fails with the following message:

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

I have verified in the sysusers table that the numeric user exists:
select * from sysusers where name = '038151'
returns 1 row

Any tips on how to give 038151 access to run the NEW_STORED_PROC ?
Thanks!

 

[gmmastros]

try replacing your single quotes with square brackets. I'm not positive, but I think it may work.

grant all on NEW_STORED_PROC to [!][[/!]038151[!]][/!];

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[ProntoMatt]

Thanks George, that did the trick!