Re: GRANT ALTER TRACE in MSSQL 2000

Krass,

On SQL Server 2000, only sysadmins can run SQL Traces.

RLF
"kkantchev@xxxxxxxxxxx" <kkantchevhotmailcom@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message news:6EB6CD69-8E98-4A64-96CB-DDD4316C6036@xxxxxxxxxxxxxxxx
Thanks Kalen,
So, I guess user needs to have sysadmin role. Is that correct?

Krass

"Kalen Delaney" wrote:

Hi Krass

The first is not possible, the second is not necessary.

--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com


"kkantchev@xxxxxxxxxxx" <kkantchevhotmailcom@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message
news:E3282092-9BAA-4025-8A8B-1086356E3464@xxxxxxxxxxxxxxxx
Hi,
How do I acomplish the following in MSSQL Server 2000?

GRANT ALTER TRACE TO <user>;

GRANT VIEW ANY DEFINITION TO <user>;

Thanks

Krass





.

Relevant Pages

  • Re: Restricting Access priviledge on SQL2000
    ... You must have made the "Application-Administrators" members of the sysadmin role in SQL Server. ... Take them out of the sysadmin role, add them as users in the correct database, then make them members of the db_owner role in that database. ...
    (microsoft.public.sqlserver.security)
  • Re: "EXEC" in SQL Server 2000 Views
    ... Kalen Delaney ... > INNER JOIN b ... > Could not execute query against OLE DB provider 'MSDASQL'. ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: waitresource
    ... SQL Server MVP ... > Also on lock escalation, i think in your Inside SQL server 2000, you ... >> Kalen Delaney ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Similar question about Auto Startup Trace
    ... >>The auto started trace should be writing to a file, ... >>Kalen Delaney ... >>SQL Server MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Getting the sa password with SQLDMO
    ... SQL Server stores passwords using a one-way hash so you can't read the ... conditional password change by attempting a connection using the expected sa ... password and, if it fails, connect using a different sysadmin role member ... member can change the sa password. ...
    (microsoft.public.sqlserver.programming)