Toad World® Forums

Newbie to Toad - Session Permission Error


#1

Hello all,

I just downloaded Toad For SQL Server on to my server and created a new account/user on SQL Server to work with.

But when I try to trace sessions, I get permission denied.

I have given it the following:

GRANT ALTER TRACE TO xxxxx;
GRANT SELECT ON SYS.TRACES TO xxxxx;

what else is required so I can conduct a session trace?

TIA…Q


#2

no one knows?


#3

Hi,

Sorry for reply you so late. Would you like try to use sys.sp_addsrvrolemember to add role member processadmin?

Best Regards,

Kelly


#4

Worked perfectly. Thank you.