Sysadmin rights to profiler - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Sysadmin rights to profiler

Author

Topic

SqlStar
Posting Yak Master

121 Posts

Posted - 2003-10-09 : 10:46:00

Hi,

If we want use SQL Profiler, that connected user should have "Sysadmin" rights.If we give this rights to that user, they will do anything in SQL server.

I want to restrict like this things eventhough profiler also work.How i can achieve?

Thanks

":-) IT Knowledge is power :-)"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-10-09 : 12:22:10

I have tried doing this as well, but I couldn't figure it out. You are supposed to just be able to grant execute permissions on some extended stored procedures according to SQL Server BOL, but it didn't work for us.

Here is a list of the SQL Profiler stored procs:

sp_trace_create, sp_trace_setfilter, sp_trace_generateevent, sp_trace_setstatus, sp_trace_setevent

Let us know if it works for you. If it does, I might look into again in case we didn't grant permissions on one of them or something like that.

Tara

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2003-10-09 : 16:48:32

granting execute permission on the extended stored procedures only worked in SQL 7. SQL2K changed it up a bit, and this trick no longer works.

see http://support.microsoft.com/default.aspx?scid=kb;en-us;310175&Product=sql2k

-ec

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-10-09 : 18:50:40

At least I know I'm not going crazy then.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources