process to protect salary information

• Curtis Smith

  Hall of Fame

  Points: 3063

  More actions

  December 8, 2003 at 3:23 pm

  #83586

  allright guru's: need to do the following, read salary information for an Oracle system into SQL Server for a computation.

  Requirements: 1) protect all salary information for all. do not store in perm. table.

  Thought about someting like this: 1) create a view on oracle. 2)create a linked server. 3)read the view into a temp table on sql server. 4) process data and drop temp table.

  pretty basic and I left out the details. but any other ideas would be welcomed.

  Curtis Smith

  Application Dev. Mgr

  DBA

  
  
  
  Curtis Smith
  SQL Server DBA
  Well in worked in Theory ...

• Steve Jones - SSC Editor

  SSC Guru

  Points: 739397

  More actions

  December 8, 2003 at 4:38 pm

  #485212

  I like it. Works well, data limited to the connection doing the work.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

  http://www.dkranch.net