Re: Informix security

Hi, The articule on "Roles - A new Security Feature in Informix 7.1" is available on my web site at: http://www.advancedatatools.com/articles.htm or at the Washington Area Informix User Groups web site at: http://www.iiug.org/~waiug/iugnew54.htm Regards - Lester Craig.Lanford@alltel.com wrote: > > I would be interested in getting the paper. Also are you guys explicitly putting > the set role in your code? That seems like the only setback in using roles. > > Thanks, > Craig Lanford > Mailto:craig.lanford@alltel.com > > > > On Fri, 13 Feb 1998, John Carlson wrote: > > >> Anyone out there setting permissions at the user level? I'd like > to > implement basic security on our system at the table level. DB > >> Privileges would be an option, but HP is not on the port list for 4gl, > >> only RDS (which we don't use). I'm not sure about BMC or Platinum; > I've > heard that those software packages can be a resource hog. > >> > >> Any options? What options? > >> > >> TIA > >> > >> John Carlson > >> Informix DBA > >> WH Smith, Inc. > >> > > > >We have done some initial testing of security using ROLES, as we are > >getting ready to put our medical database on the net. It looks > >promising, and it may be what you are looking for. ROLES are discussed > >in the Guide to 7.1 Feature Enhancements, and I have a good article on > >them that was passed on to me by Lester Knutsen of the Washington users > >group. I can pass it along if you are interested. > > ==================================================================== > Harold Luse Phone: (970) 491-4120 > Applications Programmer Fax: (970) 491-1275 > Veterinary Teaching Hospital E-mail: hluse@vth.colostate.edu > Colorado State University > Fort Collins, Colorado USA > ==================================================================== > > -- ______________________________________________________________________ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voice: 703-256-0267 Grant group privileges for Informix databases with DB Privileges Visit our Web page: www.advancedatatools.com Washington Area Informix User Group: www.iiug.org/~waiug/ ______________________________________________________________________