Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / SQL Server / ADP / August 2005

Tip: Looking for answers? Try searching our database.

Security Implementation????

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dimitrios Tanis - 13 Aug 2005 10:21 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.