sysadmin rights required to run SQL profiler

From: Simon L (anonymous@devdex.com)
Date: 07/16/02


From:     Simon L <anonymous@devdex.com>
Date: Tue, 16 Jul 2002 07:25:46 -0700


Hi All

Trying to tighten up on db security, created a user that allows only
data read/write

However (and isnt there always a however ) they also need to be able to
run profiler ..which requires sysadmin

arrghhh ! any ideas how I can satisy both needs e.g limited access, no
creation/deletion of objects etc ..but being able to run profiler

thanks then

Simon

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!