Re: Restrict Database Viewing

From: Don Grover (dgrover_at_assoft.com.au)
Date: 10/26/05

  • Next message: Sue Hoegemeier: "Re: Strange Error?" 
    Date: Wed, 26 Oct 2005 08:13:26 +1000

    I spend a lot of time writing apps against sensitive data, and often have to
    explain to clients that valid data is needed to test against.
    If you want to limit access to certain tables just create a user with
    disabled access to sensitive table and allow only access to tables they will
    use.
    If the tables that they need, have actual sensitive data in them, then
    create a duplicate database with different user and change some data.
    i.e.. if its salary then directly edit the duplicate database and change all
    the names and passwords to random data.

    My suggestion is to have a third reliable party to backup database change
    the sensitive data and return with another database name.
    Then just hand that database on cd to your programmer.

    As a second thought if its only reading i.e.. reports then create required
    tables and fields as views.

    "wrytat" <wrytat@discussions.microsoft.com> wrote in message
    news:5118B0AD-451A-406E-81F9-F6EFA426B00E@microsoft.com...
    > One of our programmers is going to write a program that involves some
    > sensitive data stored in the SQL server, using visual basic. Is there a
    > way
    > to restrict him from viewing the data in the database, yet allowing him to
    > do
    > his programming and debugging?

  • Next message: Sue Hoegemeier: "Re: Strange Error?"

    Relevant Pages

    • Re: Add a default form for start-up
      ... "Andy" wrote: ... > Make the sensitive data not readable by anyone except the db Administrator. ... >> The main database has very sensitive material in it. ... Each manager is only ...
      (microsoft.public.access.modulesdaovba)
    • Server setup file encryption
      ... Our webapplication needs to access highly sensitive data. ... currently there are 2 boxes, 1 MySQL database server and 1 Apache webserver (with sensitive data) both running Linux. ...
      (Security-Basics)
    • Securing/encrypting sensitive data with clear display in DataGrid
      ... I have an application that contains some sensitive data. ... ADO.NET DataSet for the database access. ... to provide clear-text display to authorized users. ... using a DataSet bound to a DataGrid surely would encounter this issue. ...
      (microsoft.public.dotnet.framework.aspnet.webcontrols)
    • Secure local database
      ... I have an Access 2002 database on my home business computer which ... contains a lot of sensitive data. ... from the internet, and I only have a dialup connection. ...
      (microsoft.public.access.security)