>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