Re: Security Implementation????



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


--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"Dimitrios Tanis" <jtanis@xxxxxxxxxxx> wrote in message
news:eaAdDj%23nFHA.2444@xxxxxxxxxxxxxxxxxxxxxxx
>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)
  • Security Implementation????
    ... Because of my recent upsizing to MSDE, ... In the logins node of my MSDE instance I have 2 users: ... In my db node my windows account is mentioned as owner. ... I want to distribute the database and I want to make the BE as secure as ...
    (microsoft.public.access.adp.sqlserver)
  • Security Implementation???
    ... Because of my recent upsizing to MSDE, ... In the logins node of my MSDE instance I have 2 users: ... In my db node my windows account is mentioned as owner. ... I want to distribute the database and I want to make the BE as secure as ...
    (microsoft.public.sqlserver.security)
  • MSDE2000 deployment
    ... How attach existing database in MSDE when run setup.exe in my visual ... Validate whether the MSDE instance is started. ...
    (microsoft.public.sqlserver.msde)
  • 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)