Database Security in ADP

  • Thread starter Thread starter Ted Theodoropoulos
  • Start date Start date
T

Ted Theodoropoulos

one really nice feature of A2K adp's was the ability to manipulate sql
server security by using the interface under tools->security->database
security. from what i understand that feature is missing from XP
because ms didn't want users to be able to get by too easily using
MSDE.

what happens, for example, if u do own a license to sql server and
want to provide a way to create logins, etc from within access? well
i guess u write ur own. it seems like the code could get slightly
involved though querying the network for domains and users within
those domains, etc.

it seems like one could manipulate the security objects via SQL-DMO
but that would require installing that library on every client. well,
access is bringing up what looks to be that native sql server dialog
that u get in EM somehow in A2K. is this functionality built in to
access or does access install the dmo library by default?
unfortunately i don't have a machine with just access and not sql
server handy. also, is there some code or an add-in that someone has
written that allows u to accomplish this?

sorry for cross-posting but *specific* adp/sql questions often don't
get alot of responses. thanks in advance for your thoughts.
 
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
 
Back
Top