Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2011
    Posts
    45

    Question Unanswered: masking of new updated data

    Hi all,
    We were in need to hide client details from local users.
    For this I have used translate function and translated the data, but what will happen if we insert a new record into the table or update any existing records??
    will it get automatically masked or we need to mask it again.
    If it will not get automatically masked then, is there any way to do this automatically.

    Regards,
    Harsh

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    maybe LBAC is a solution ?
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Aug 2011
    Posts
    45
    Thanks for ur response,
    I am having version 8.2 and as per my knowledge LBAC is available from Version 9.

    Regards,
    Harsh

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Only allow the users to read the data through views and then mask the data in the views.

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •