Re: Informix vs SQL Server questions
Posted in 1996
Topics: Security, Permissions & Auditing
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 } }