grant alter trace to a domain account

surprisingly, couldn't find anything about granting alter trace permissions toa domain account.

Itry to run following sql:

GRANT ALTER TRACE TO MyDomain\User1;
GO

And get the following error when executing:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '\'.

What is correct SQL to grant alter trace permissions to a domain account?

TIA.

March 12th, 2007 7:01pm

You must enclose the name between brackets:

GRANT ALTER TRACE TO [MyDomain\User1];

Thanks
Laurentiu

Free Windows Admin Tool Kit Click here and download it now
March 12th, 2007 8:40pm

Thanks much for your help. Much appreciated.
March 13th, 2007 4:08pm

Merci bcp
Free Windows Admin Tool Kit Click here and download it now
August 1st, 2015 1:23pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics