Re: roles and transaction logging

>Date: Mon, 1 Mar 1999 11:06:48 -0700 (MST) >From: Luse Harold <hluse@vth.colostate.edu> >To: Austin Castro <acastro@btl.net> >Subject: Re: roles and transaction logging > >On Sat, 27 Feb 1999, Austin Castro wrote: > >> Hi guyz, >> >> Transaction logging and roles seems to be like oil and water. For one >> I've found out that you cannot issue a set role command within a >> transaction block (in informix 4gl). So to overcome this i issue my set >> role statement then I issue my begin work statement. This works fine >> except that the user still cannot insert into the table. I've granted >> permissions to the role and I've assigned the user to the role. What am i >> doing wrong? And why can't you issue a set role statement within a >> transaction block? >> >> >> austin >> >> >Did you prepare the set role statement? > >==================================================================== >Harold Luse Phone: (970) 491-4120 >Veterinary Teaching Hospital Fax: (970) 491-4123 >Colorado State University Pager: (970) 229-8173 >Fort Collins, Colorado USA E-mail: hluse@vth.colostate.edu >==================================================================== > Yes I Did, what was happenning though was that there were other roles being set and only one role can be set at time. So when I issued my insert statement the role i intended to do the insert was no longer in effect. austin