I've implemented passwords for security on my DB. One set of rights has
select and update only to a certain table. I have an option on the form to
change the sort order of the table. So when they change to alphabetical
sort, for instance, the code first closes the query that accesses the table,
changes the SqlOrder, and then reopens. The problem happens on the close.
I get an IBO error: "No permission for insert/write access to the table [my
table name]." This query is not linked to anything else. No activites were
performed. I just open the form and change the setting and this error comes
up. I get it 3 times. Then the code continues to reopen the query and that
fails too.

Here's the code. It works fine when I'm logged in as Sysdba:

try
dmRReq.ibqAllPartnerInfo.Close;
except
showmessage('Error on Close of partner info.');
end;
dmRReq.ibqAllPartnerInfo.SQLOrder.Clear;
if cbMemberSort.Text = 'Alphabetical' then
dmRReq.ibqAllPartnerInfo.SQLOrder.Add('Order By Last_name, First_name,
Middle_name')

else if cbMemberSort.Text = 'By Prayer Day' then
dmRReq.ibqAllPartnerInfo.SQLOrder.Add('Order By Prayer_day');

try
dmRReq.ibqAllPartnerInfo.Open;
except
showmessage('Cannot re-open partner info data.');
end;


Why is it needing insert/delete rights?

Delphi 4, IBO 4.2.Fa, IB 6.0.1.6.

Thanks.
--

Don Gollahon
(dlgllhn@...)