RE: Informix Data Masks

Posted in 2003

Alexey Sonkin — Tue, 15 Jul 2003 16:53:32 -0400 — source: Usenet: comp.databases.informix

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C34B13.2690EE00 Content-Type: text/plain Hi, Chavan, You can revoke access to that table at database-level and at table-level from the particular user and give him column-level access to that table. ------------------------------------------ Alexey Sonkin Senior Database Administrator -----Original Message----- From: Chavan Koya [mailto:chavankoya189@hotmail.com] Sent: Tuesday, July 15, 2003 10:05 AM To: informix-list@iiug.org Subject: Informix Data Masks All, Could anyone tell me as to how to set up a mask on Informix 7.2 that basically hides the actual data stored in a column by replacing it with asterix when queried upon by a user.. ie. no encryption only an edit/display mask like for instance password column that user can select from but not see the actual contents. Thanks CK ------_=_NextPart_001_01C34B13.2690EE00 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html xmlns:v=3D"urn:schemas-microsoft-com:vml" = xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40">; <head> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3DUS-ASCII"> <meta name=3DProgId content=3DWord.Document> <meta name=3DGenerator content=3D"Microsoft Word 10"> <meta name=3DOriginator content=3D"Microsoft Word 10"> <link rel=3DFile-List href=3D"cid:filelist.xml@01C34AF2.8506EAF0">  <style>  </style>  </head> <body bgcolor=3Dwhite lang=3DEN-US link=3Dblue vlink=3Dpurple = style=3D'tab-interval:.5in'> <div class=3DSection1> Hi, = Chavan,<o:p></o:p> <o:p> </o:p>= You can revoke access to that = table at database-level and at table-level<o:p></o:p> from the particular user and give = him column-level access to that table.<o:p></o:p> <o:p> </o:p>= <div> ------------------= ------------------------<o:p></o:p> Alexey = Sonkin<o:p></o:p> Senior Database Administrator<o:p></o:p>  </fo= nt><o:p></o:p> </div> <div style=3D'border:none;border-left:solid blue 1.5pt;padding:0in 0in = 0in 4.0pt'> -----Original Message----- From: Chavan Koya [mailto:chavankoya189@hotmail.com] Sent: Tuesday, July 15, = 2003 10:05 AM To: = informix-list@iiug.o