Post reply

Profiler & Server admin role

  • January 29, 2002 at 3:46 am

    #77771

    Hi,

    I am just wondering if it is possible to give permissions to a login to run profiler without assigning it to sysadmin server role.

    Can this be done by giving execute privileges on selected stored procs/functions...

    This is in SQL 2000/

    Thanks & Regards,

    Mitra

  • January 29, 2002 at 11:58 am

    #422815

    Don't believe so. you'd have to test it, but I believe that they can directly. BOL shows most procedures need syadmin roles setup.

    You could create a job for people that rnus the stored procedures. If the job is owned by the user, they will run it under the SQLAgent proxy account. You could make this account a sysadmin, but I'd be REALLY wary of doing this.

    Steve Jones

    steve@dkranch.net

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply