Re: Security Suggestions??

From: Jeff Cochran (jcochran.nospam_at_naplesgov.com)
Date: 02/25/04


Date: Wed, 25 Feb 2004 22:27:45 GMT

On Wed, 25 Feb 2004 06:57:20 -0800, "Tom Hart"
<anonymous@discussions.microsoft.com> wrote:

>I have a client with a software package and many Access
>DB's developed around the package to support additional
>functionality. Currently the only security is the SQL
>logoin ID for all databases. The client needs to tighten
>this down, but doesn't want to invest the time to put
>security in all the additional supporting db's. Is there
>any packages or such that will provide a level security
>greater than they have now and provide user level security
>to each database?

Access databases don't have a SQL login ID. :)

The answer is no. You *may* be able to use NTFS permissions to
restrict access to the physical MDB files depending on what you need
to accomplish.

Jeff



Relevant Pages

  • Re: Whats best practice for connecting to a Sql Server database
    ... possible) since it provide more security. ... Microsoft MSDN Online Support Lead ... What's best practice for connecting to a Sql Server database ... Co-author of "The .NET Developer's Guide to Directory Services ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Windows update fails for KB948109 (sql 2005 sp2)
    ... There is no charge for support related to installing a Security Update. ... "When you call please let them know that this has to do with Security Bulletin MS08-040. ... and he just said to remove SQL. ...
    (microsoft.public.windowsupdate)
  • Re: Help with sorting Access table using ASP
    ... If your server does not support SQL you cannot use any databases. ...
    (microsoft.public.frontpage.programming)
  • Re: Access Retirement
    ... I will not attempt to guess whether you should migrate the databases to SQL ... Server or not as I don't have nearly enough information. ... > Access 97 support. ...
    (microsoft.public.access.conversion)
  • using sa with SQL 2005 problem??
    ... I un-installed SQL 2000 developer's edition and installed SQL 2005 developer's ... attached my old databases. ... the sa user/pass in my connection strings. ... security logins, but I've got a lot of code that would need to be changed. ...
    (microsoft.public.dotnet.framework.aspnet)