SP_TRACE_CREATE in MSSQL 2000

[Derftics]

Hello,

Is there a way how could I execute the stored procedure SP_TRACE_CREATE without granting a system administrator role to the login id that will execute the said stored procedure?

Thank you.

[iburyak]

Hello,

Is there a way how could I execute the stored procedure SP_TRACE_CREATE without granting a system administrator role to the login id that will execute the said stored procedure?

Thank you.

Only members of the sysadmin fixed server role can execute sp_trace_create.

I didn't test it but try to create your own stored procedure that calls sp_trace_create inside and grant rights to that proc to your user I think it is not going to work but it is worth of trying.

Good Luck.

[Derftics]

Only members of the sysadmin fixed server role can execute sp_trace_create.

I didn't test it but try to create your own stored procedure that calls sp_trace_create inside and grant rights to that proc to your user I think it is not going to work but it is worth of trying.

Good Luck.

Thank you, I have tried it before but doesn't work. I guess I have no choice but to grant the user id with system administration role. Thanks again.

[iburyak]

You know what else I do in cases like this.

I create a separate connection to the server with batch account with granted rights just for that particular step or you can create DLL \EXE that connects to the server with your name or batch account that has rights and call it from your application.
I would never grant sysadmin rights to regular user.

I call this technique - create a blob that has necessary rights for specific step in a program.

Good Luck.
Irina.