Security Implementation????

D

Dimitrios Tanis

I have a adp that I want to protect. Because of my recent upsizing to MSDE,
I am kind of lost!

I got Andrea Montanari's Dbamgr2k to handle security issues but still...
In the logins node of my MSDE instance I have 2 users: sa and
BUILTIN\Administrators both pointing to the "master" database of MSDE.
In my db node my windows account is mentioned as owner.
In users node in the db node, only dbo with no login name exists.
When I choose to see the currently connected users, I see two instances of
my windows account.

What do I have to change to:
1. Make the security machine independent,
2. Prevent all users but me to see and alter the BE
3. Where do I setup common users?

PS. I want to distribute the database and I want to make the BE as secure as
possible both from theft of data and DB design.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top