Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Managing SQL Login Accounts and permissions
Message
From
18/06/1999 15:34:58
 
 
To
18/06/1999 11:57:15
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00231460
Message ID:
00231558
Views:
16
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform