From: Iñigo Salvat <inigo@isalvat.es>
To: Jeremiah Ocasio <jocasio@kaleidoscopemediasystems.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Data Masking
Date: Tue, 16 Dec 2014 08:44:36 +0100
Message-ID: <548FE2E4.3080901@isalvat.es> (raw)
In-Reply-To: <CAKqpGf5WUAaUoo8XiTDed9g-vxRKw0OK7qGxPNEbpBP5tmNgJw@mail.gmail.com>
References: <5488C179.3090609@isalvat.es>
<CAKqpGf5H74AJ+jKJx=5iUxwOOOyzJ7_kxD1NJXeHyTvp4UGBcA@mail.gmail.com>
<548D7A0E.1040905@isalvat.es>
<CAKqpGf5WUAaUoo8XiTDed9g-vxRKw0OK7qGxPNEbpBP5tmNgJw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi,
Thanks for the link it is great but, as I need to do that on hundreds of
databases, I'm looking for a tool to automatice -as much as posible- the
process.
Iñigo
El 15/12/14 23:30, Jeremiah Ocasio escribió:
> Hello all,
>
> For your masking action are you looking to de-identify user specific
> data for testing purposes? if that is the case I found this article
> helpful when setting up my test environment.
>
> http://www.mssqltips.com/sqlservertip/3091/masking-personal-identifiable-sql-server-data/
>
> Thanks,
> Jeremiah
>
> On Sun, Dec 14, 2014 at 3:52 AM, Iñigo Salvat <inigo@isalvat.es
> <mailto:inigo@isalvat.es>> wrote:
>
> Hi all,
>
> The goal is to recover production data and mask it in a second
> server for testing purposes.
>
> Thanks for your help,
>
> Iñigo
>
>
> El 12/12/14 21:58, Jeremiah Ocasio escribió:
>> Hello,
>>
>> What is your goal for the Masking? There are lots of options out
>> there but letting us know the environment you wish to work within
>> and the end goal of the masking will help get you the best answers.
>>
>> Thanks,
>> Jeremiah
>>
>> 2014-12-10 13:56 GMT-08:00 Iñigo Salvat <inigo@isalvat.es
>> <mailto:inigo@isalvat.es>>:
>>
>> Hi all,
>>
>> Does any of you know about a good data masking tool for
>> databases that include support for Postgresql, of course, and
>> any other odbc/jdbc database.
>>
>> Thanks,
>>
>> --
>> Iñigo Salvat
>>
>> __________________
>> La presente información se envía únicamente para la persona a
>> la que va dirigida y puede contener información de carácter
>> confidencial o privilegiada. Cualquier modificación,
>> retransmisión, difusión u otro uso de esta información por
>> personas o entidades distintas a la persona a la que va
>> dirigida está prohibida. Si usted lo ha recibido por error
>> por favor contacte con el remitente y borre el mensaje de
>> cualquier ordenador. Para el caso de que este mensaje vaya a
>> ser contestado por la misma vía, ha de saberse que su
>> respuesta podría ser conocida por terceros al entrar en la
>> red. Por ello, si el mensaje incluye contraseñas, números de
>> tarjetas de crédito o cualquier otra información que usted
>> considere confidencial, sería más seguro contestar por otra
>> vía y cancelar su transmisión. El autor no puede asumir la
>> responsabilidad derivada del hecho de que terceras personas
>> puedan llegar a conocer el contenido de este mensaje durante
>> su transmisión.
>>
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org
>> <mailto:pgsql-admin@postgresql.org>)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>>
>>
>> --
>> Jeremiah Ocasio
>> jocasio@kaleidoscopemediasystems.com
>> <mailto:jocasio@kaleidoscopemediasystems.com>
>>
>>
>>
>> 1200 Westlake Ave N, Suite 604
>> Seattle, WA 98109
>> Tel: 855-247-5231 <tel:855-247-5231>
>> Fax: 206-400-2712 <tel:206-400-2712>
>>
>> This electronic mail communication is intended only for the
>> individual or entity to which it is addressed and contains
>> privileged and confidential information. If you receive this
>> communication in error, please advise us by return e-mail or call
>> us immediately at 855-247-5231 <tel:855-247-5231> and delete this
>> communication and all copies and attachments. Any dissemination,
>> distribution or copying of this communication is strictly prohibited.
>>
>> IRS Circular 230 disclosure: To ensure compliance with
>> requirements imposed by the IRS and other taxing authorities, we
>> inform you that any tax advice contained in this communication
>> (including any attachments) is not intended or written to be
>> used, and cannot be used, for the purpose of (i) avoiding
>> penalties that may be imposed on any taxpayer or (ii) promoting,
>> marketing or recommending to another party any transaction or
>> matter addressed herein.
>
>
>
> --
> Jeremiah Ocasio
> jocasio@kaleidoscopemediasystems.com
> <mailto:jocasio@kaleidoscopemediasystems.com>
>
>
>
> 1200 Westlake Ave N, Suite 604
> Seattle, WA 98109
> Tel: 855-247-5231
> Fax: 206-400-2712
>
> This electronic mail communication is intended only for the individual
> or entity to which it is addressed and contains privileged and
> confidential information. If you receive this communication in error,
> please advise us by return e-mail or call us immediately at
> 855-247-5231 and delete this communication and all copies and
> attachments. Any dissemination, distribution or copying of this
> communication is strictly prohibited.
>
> IRS Circular 230 disclosure: To ensure compliance with requirements
> imposed by the IRS and other taxing authorities, we inform you that
> any tax advice contained in this communication (including any
> attachments) is not intended or written to be used, and cannot be
> used, for the purpose of (i) avoiding penalties that may be imposed on
> any taxpayer or (ii) promoting, marketing or recommending to another
> party any transaction or matter addressed herein.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: inigo@isalvat.es, jocasio@kaleidoscopemediasystems.com
Subject: Re: Data Masking
In-Reply-To: <548FE2E4.3080901@isalvat.es>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox