By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,534 Members | 943 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,534 IT Pros & Developers. It's quick & easy.

Setting Security

P: n/a
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
Nov 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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/techinf...ty/default.asp

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

On Mon, 12 Jan 2004 17:28:19 -0800, "Anthony Taing"
<an*******@discussions.microsoft.com> wrote:
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


Nov 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.