Database Security in ADP

thanks mary. i'm not having any problems as the developer. my
machine has EM so no biggie. i want to allow a small hand full of
managers to be able to add users to the application. what i don't
want to do is install EM on each of their machines. they've made it
clear that they want to do it from within the app. so i need to write
my own little GUI i suppose.
adding sql server logins is a snap (sp_adduser) but because the app
uses integrated security i need to provide a dialog similar to that of
EM where the users can select a domain and view a list of users within
that domain. not quite sure how to accomplish that. do i need
sql-dmo? any ideas would be appreciated.
TIA

> To address the issue of people not being able to administer SQLS/MSDE
> security through an easy-to-use GUI, msft has made the Developer
> edition available for $49. The answer is, use the Enterprise Manager.
> -- Mary
> Microsoft Access Developer's Guide to SQL Server
> http://www.amazon.com/exec/obidos/ASIN/0672319446
>Yes -- SQL-DMO is what you need.
-- Mary
MCW Technologies
http://www.mcwtech.com
On 11 Mar 2004 06:54:25 -0800, teddy_theo@.yahoo.com (Ted
Theodoropoulos) wrote:
>thanks mary. i'm not having any problems as the developer. my
>machine has EM so no biggie. i want to allow a small hand full of
>managers to be able to add users to the application. what i don't
>want to do is install EM on each of their machines. they've made it
>clear that they want to do it from within the app. so i need to write
>my own little GUI i suppose.
>adding sql server logins is a snap (sp_adduser) but because the app
>uses integrated security i need to provide a dialog similar to that of
>EM where the users can select a domain and view a list of users within
>that domain. not quite sure how to accomplish that. do i need
>sql-dmo? any ideas would be appreciated.
>TIA
>