Re: Field Level Security in ISQL?

------------- Begin Attached Message ------------- Message-Version: 2 From: cbnewsk!att!rmy.emory.edu!informix-list-owner Date: Wed Oct 9 11:27:06 EDT 91 Received: by att.att.com; Fri Oct 11 11:36:08 EDT 1991 Received: from csslc.rmy.emory.edu by Received: rmy.rmy.emory.edu (5.65/Emory_rmy.3.2.6) via SMTP Received: id AA27851 ; Fri, 11 Oct 91 11:35:52 -0400 Received: from emory.UUCP by Received: rmy.rmy.emory.edu (5.65/Emory_rmy.3.2.6) via UUCP Received: id AB23040 ; Fri, 11 Oct 91 09:30:43 -0400 Received: from mnopltd.UUCP by Received: emory.mathcs.emory.edu (5.65/Emory_mathcs.3.2.11) via UUCP Received: id AA07200 ; Thu, 10 Oct 91 18:58:16 -0400 End-of-Header: Email-Version: 2 Return-Path: informix-list-owner@rmy.emory.edu Message-Id: <9110102258.AA07200@emory.mathcs.emory.edu> Subject: Field Level Security in ISQL? To: cbnewsk!att!rmy.emory.edu!rmy!informix-list@emory.UUCP (Informix Discussion List) X-Mailer: ELM [version 2.2 PL11] X-Informix-List-Id: <list.502> End-of-Protocol: Content-Type: text Content-Length: 587 The old Informix (a.k.a. "informix-classic") had a method of specifying certain table fields only visible to certain users. I find no such mechanism in ISQL. (2.10) It this true, or are we looking in the wrong place? ------------------------------------------------------------------------------ Neal Rhodes MNOP Ltd (404)- 972-5430 President Lilburn (atlanta) GA 30247 Fax: 978-4741 emory!mnopltd!neal ------------------------------------------------------------------------------ Try lookup under the grant command, the example shows granting select (retreive data) permissions on certain fields. it goes like this grant select(fname,lname,company,city) on customer to {public|userid}; Thanks, Van ------------------------ James F. Van Valkenburg a.k.a. "van" AT&T Attmail: !jfv jfv@cbnewsk.att.com Atlanta, GA. Voice 404-810-7920 =============================================================================== ---- Standard Disclaimers included -- Just another grunt at AT&T ---- ===============================================================================