Setting Security

[Anthony Taing]

I have an MSDE database running on a PC, and i want users
to be able to connect to it via my app. At the moment, the
only way they can successfully connect is if i give them
full admin rights to that machine.

Could someone tell me specifically what i need to give
them access to to allow them to access the database? I
don't want to give them full access. I have tried giving
them full access to MSSQL\Data directory, however this has
not fixed it.
Any ideas?
Thanks,
Anthony

 

[Mary Chipman]

MSDE is really just SQL Server with some limitations, so you need to
implement SQLS security. Making users administrators is a sure recipe
for disaster and is never the right answer to an application access
problem. A good place loaded with resources is
http://www.microsoft.com/sql/techinfo/administration/2000/security/default.asp

-- Mary
MCW Technologies
http://www.mcwtech.com