Re: Informix vs SQL Server questions

Check the Informix "Guide to 7.1 Feature Enhancements" for create role, drop role and set role. For Grant and Revoke see the Informix Guide to SQL:Syntax. ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On 15 May 1996, William Harris wrote: } In article <4nb4u7$2vk@cssun.mathcs.emory.edu>, billy.wheeler@pixie.co.za } says... } >>6) From what I can tell from what I've read, Informix can assign } >>access rights for a user at the table level (and select rights at a } >>column level). I didn't see anything mentioned about groups. In SQL } >>Server we have assigned table access rights to particular *groups*. } >>Then we assign users to that group to gain access to the tables which } >>that group has rights to. Does Informix support this scenario? } > } >Informix supports ROLEs.Same sort of thing. } } I've seen some mention of ROLEs here and there - where are they documented? } I'm looking at Informix 7.x documentation that makes no mention whatsoever of } roles. Is it an Informix 7.x feature? } } How does it fit in with "standard" SQL? } -- } William Harris william@carsinfo.com } CARS Information Systems } 4000 Executive Park Drive } Cincinnati, OH (USA) 45241 } }