Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Managing SQL Login Accounts and permissions
Message
De
18/06/1999 15:34:58
 
 
À
18/06/1999 11:57:15
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00231460
Message ID:
00231558
Vues:
17
>I know that I can use SQL Enterprise Manager to view each user's information individually, but is there a SQL built-in stored procedure or something that would aid administrator to manage login accounts and access information for all users within a SQL server in the form of report or something?
>
>Or is there a third-party utility that anyone knows of that would perform the above task?
>
>Thanks in advance for your help.
>
>CARIE

I'd suggest looking into SQL-DMO for what you want to do. SQL-DMO is an component object model that exposes administrative functions. There are collections for logins and users.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform