Security Implementation????



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.


.



Relevant Pages

  • Re: Cannot save document. Form Validation Error..Web Server is busy
    ... installed as a MSDE instance in the first place. ... on reconfigure SP to point to the right database server. ... > would be to stop MSDE copy the databases and log files. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Data corruption with SQL server installed
    ... I noticed that the rogue Primary key that appeareed with the .AddNew method ... The installation of MSDE comes after the installation of MDAC 2.8, ... you could create an empty database and import everything into ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Put database on Internet
    ... > Once you will be able to connect to MSDE or to SQL-Server, ... > and ADP in the same time as frontends to your database. ... >> will be able to serve as SQL server. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Connect to Access Data from various regional locations
    ... All users will be connecting via broadband. ... When using MSDE ... > Dim rf As DAO.Recordset ... > There is a wizard to split your database into a FE and a BE; ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Using vfoledb with webservices?
    ... MSDE database can handle at full speed. ... capabilities of Microsoft Access or, in the reasonable opinion of Microsoft, ... and unless Licensee Software requires your customers ...
    (microsoft.public.fox.programmer.exchange)

Loading