Re: ACE and SET ROLE

In article <34E07EA6.1E89@uk.ibmmail.com>, Peter Ede <peter_ede@uk.ibmmail.com> writes >Hi. > >We have a 7.22uc1 Online DSA database and we have a need for high levels >of security. Extensive use of Stored Procedures have been deployed to >cater for data access/changes within the application. Table privileges >are allocated to ROLES, the application using SET ROLE where required. > >Now we need to provide ad hoc reporting facilities. The Informix report >writer ACE was written many moons before ROLES where introduced (to >Informix), so what's the alternative ? > Don't know that there is one. Any PC ODBC-based solution would involve letting the users know what roles exist and how to use them. >If we use ACE we could separate the SQL from the report: by using >ISQL/DBACCESS, SET ROLE and SELECT ... into an ascii file. Then use ACE >with a READ statement. Not very elegant. > >Has anyone else run into this problem ? Any solutions ? >Any other report writers that understand ROLES ? > >Regards >Peter Ede >IBM UK. ><No name - no pack drill> -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care