Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to do a Trace without being SA(sql2000)
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00537354
Message ID:
00537514
Vues:
12
OK:
But I cant deny permissions to a user that is defined as a menmber of Sysadmin group, Can I?

Thanks Michael


From BOL:

With Windows Authentication mode, the user account that runs SQL Profiler must be granted permission to connect to an instance of SQL Server. The login account also must be granted permissions to execute SQL Profiler stored procedures.

One of those stored procedures is sp_trace_create which, according to the BOL, requires the caller to be a member of the sysadmins group.

-Mike

Ariel Gimenez

our power is our knowledge

Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform