Can I prevent some of users with sysadmin role to create table?

  • Hello,


    Because there is no other way to use profiler except to have sysadmin fixed role, I have to give this role to one account for use for developers. But, I also wan to prevent then to use this login for anything else, including create objects and execute sp!! Is there any way to do this?   




  • I think not    


  • I guess the real question is....

    WHY are you allowing DEVELOPMENT to run PROFILER (which if done incorrectly can bring your server to a halt) on PRODUCTION (Assumption)?????

    I would want to be right there doing the profiler on MY PROD server....

    1.  You know who is going to get called when the system starts getting slow

    2.  You know how to set-up profiler properly

    3.  BAD juju allowing DEV to run amok....

    Good Hunting!

    AJ Ahrens

  •     Unfortunately, I HAVE TO allow developers to run profiler for maintenance purpose (for several applications) on production server. That is the way it is. Thanks, anyway.

  • What you can do is run Profiler and have it put the information into a trace table or trace file (with rollover). Then give the developers access to the trace table or trace file location. This allows them to get Profiler data in almost real time without having those kinds of rights on your SQL Server.

    K. Brian Kelley

  • Cool,

    It is nice solution, and with some modification, it can be usefully.

    Of course, it will be better if they can run profiler with their custom settings, but it is good enough for now.

    Thanks a lot.


  • Our users once in a while need to make changes to the production. So if their mamager approves that, they call/mail DBA with ticket number.

    We execute a process which adds that person to a Special Role on a server ( with sysadminn rights) and fire a profiler which collects all the info on that developer. Once changes are made, we revoke his access to that Special Role and stop the trace. Auditors/managers can always review the trace.

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

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