Re: how to give developer right to run SQL profiler without assign them SA right

From: Kevin (ReplyTo_at_Newsgroups.only)
Date: 09/16/03 

Date: Mon, 15 Sep 2003 20:51:34 -0700

You can reverse engineer the security by determining what stored procs
and/or user functions are called by profiler, and then grant access to
those, or, another route, if you don't need real time access, is to setup a
server side trace to a file and give the developer read access to at file
share that contains the trace data.

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:9jdcmvcr5krbj1t4p2lrge113gi8i8974j@4ax.com...
> You can't with SQL 2000. Needs to be a sysadmin.
>
> -Sue
>
> On Mon, 15 Sep 2003 13:17:56 -0700, "mike"
> <mikewangdba@hotmail.com> wrote:
>
> >it is SQL 2000 box.
>

Quantcast