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.
Sylvain Lafontaine - 13 Aug 2005 19:45 GMT
If you would be a better idea if you make your post in the newsgroup
m.p.sqlserver.security. Go with Google if you want access to the full
archive:
http://groups-beta.google.com/group/microsoft.public.sqlserver.security

Signature
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
>I have a adp that I want to protect. Because of my recent upsizing to MSDE,
>I am kind of lost!
[quoted text clipped - 14 lines]
> 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.