Re: Profiler Security

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 01/09/04

  • Next message: Nuno: "Creating a User in Sql...." 
    Date: Thu, 8 Jan 2004 20:58:13 -0600

    > This really is not a good enough answer, from a
    > development point of view alot of companies need to give
    > their developers access to use SQL Profiler and do not
    > want to assign the developers the sys admin sql role.
    >
    > Will there be a way in the future to get around this?
    > This is a hot topic with alot of people and we are all
    > looking for a way around this.

    A lot of folks agree and it looks like this may make it into the next
    version of SQL Server. From last month's chat:

    <Excerpt
    href="http://www.microsoft.com/technet/treeview/default.asp?url=/technet/itc
    ommunity/chats/trans/SQL/sql1209.asp">

    Host: DanWinn (Microsoft)

    Q: Why can't Profiler run without logging in as Admin? Profiler is very
    useful for developers, but I don't want to give them admin rights.

    A: In SQL Server 2000, one requires admin rights to create a SQL Trace. As
    such, Profiler must log in as an admin. In Yukon, there is an ALTER TRACE
    permission which may be granted to non-admins which allows them to create a
    SQL Trace.

    </Excerpt> 

    -- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Darryl Stovell" <subscriptions@hambs.com.au> wrote in message
news:066801c3d63d$32689650$a101280a@phx.gbl...
> This really is not a good enough answer, from a
> development point of view alot of companies need to give
> their developers access to use SQL Profiler and do not
> want to assign the developers the sys admin sql role.
>
> Will there be a way in the future to get around this?
> This is a hot topic with alot of people and we are all
> looking for a way around this.
>
> Thanks
>
> >-----Original Message-----
> >Sorry, you need to be a member of the sysadmin role.
> >
> >--
> >Tom
> >
> >---------------------------------------------------------
> ------
> >Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> >SQL Server MVP
> >Columnist, SQL Server Professional
> >Toronto, ON Canada
> >www.pinnaclepublishing.com/sql
> >
> >
> >"Manoj Raheja" <anonymous@discussions.microsoft.com>
> wrote in message
> >news:035e01c3d510$f81fc310$a001280a@phx.gbl...
> >How to run profiler with login other than sa \ sa rights.
> >Is there any other way I can specify the permissions to a
> >user for only executing Trace \ Profiler.
> >
> >Thanks,
> >Manoj Raheja
> >manoj.raheja@hotmail.com
> >
  • Next message: Nuno: "Creating a User in Sql...."

    Relevant Pages

    • Re: Profiler Security
      ... want to assign the developers the sys admin sql role. ... This is a hot topic with alot of people and we are all ... >How to run profiler with login other than sa \ sa rights. ...
      (microsoft.public.sqlserver.security)
    • Re: crash on virtual dimensions
      ... SQL authentication doesn't work for SQL Server to anywhere. ... It is basically a way for access developers to start writing all of their ...
      (microsoft.public.sqlserver.olap)
    • Re: Opinions on 3rd party code generators?
      ... The high level documentation appears to suggest they're ... How had is it to write Select InvoiceID, ... They claim you don't need to know SQL to use their tools. ... developers don't understand SQL. ...
      (microsoft.public.dotnet.languages.csharp)
    • Re: Visual Query Builder (Was: Its Official: CodeGear EnjoyingDouble-Digit Profit Rate)
      ... developers is a 'pretty' selling feature. ... inferior solution, I invite you to think of ways it could give you a ... code completion for SQL in there for good measure. ... CodeGear Developer Network: http://dn.codegear.com ...
      (borland.public.delphi.non-technical)
    • Re: Security - give developers read access to prod DBs
      ... > We have a test SQL 2000 server where most developers have their own SQL ... > databases on the prod SQL instance where all development databases are ...
      (microsoft.public.sqlserver.server)