Re: Restrict Database Viewing

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 10/25/05

  • Next message: Don Grover: "Re: Restrict Database Viewing" 
    Date: Tue, 25 Oct 2005 07:47:42 -0500

    Rather than developing against the live production database, consider
    developing the application against a test database with identical schema.
    You can use test data or obfuscated production data for testing. 

    -- 
Hope this helps.
Dan Guzman
SQL Server MVP
"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: Don Grover: "Re: Restrict Database Viewing"

    Relevant Pages

    • Re: dbdebunk Quote of Week comment
      ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
      (comp.databases.theory)
    • Re: dbdebunk Quote of Week comment
      ... > a lot of really bad SQL programmers. ... a surrogate key should support the primary key. ... But SQL does not have a pointer data type or the ... > being told to design a database. ...
      (comp.databases.theory)
    • Re: dbdebunk Quote of Week comment
      ... But SQL does not have a pointer data type or the ... More and more programmers who have absolutely no database training are ... But why is little Cindy Lou Who employee ...
      (comp.databases.theory)
    • Re: What is Pick anyway?
      ... > company or organization that controls the integrity of a database? ... are managed by separate departments, using separate packages, purchased from ... and maintained by separate teams of programmers. ... database environments. ...
      (comp.databases.theory)
    • Re: Delphi bugs and "moving" to Visual Studio debate
      ... > the enterprise database architecture. ... > Most programmers do not get to choose the IDE for their next project. ... our European offices use Oracle ...
      (borland.public.delphi.non-technical)