Audit on 1 db

Hi guys
I need to give a contractor access to Audit/Trace 1 database. The contractor
also needs to be able to create, drop, insert, delete & update 1 database on
a server.
At the moment I have added him to the System Administrator role. Is there
any way I can restrict him to only the ONE database he actually needs to
access or does he need to System Admin role in order to Audit/trace.
Thanks.
Regards
JonasUsing profiler with SQL Server 2000 requires being a member
of sysadmin
If it's SQL Server 7, you can grant execute permissions on
the Profiler extended stored procedures - xp_trace_* and
xp_sqltrace.
-Sue
On Mon, 2 Aug 2004 11:17:09 +1000, "Jonas Larsen"
<Jonas.Larsen@.Alcan.com> wrote:

>Hi guys
>I need to give a contractor access to Audit/Trace 1 database. The contracto
r
>also needs to be able to create, drop, insert, delete & update 1 database o
n
>a server.
>At the moment I have added him to the System Administrator role. Is there
>any way I can restrict him to only the ONE database he actually needs to
>access or does he need to System Admin role in order to Audit/trace.
>Thanks.
>Regards
>Jonas
>