Subject Re[4]: [IBO] problem with permissions
Author Ramil
Hi Alan,
27.04.2005 15:20, you wrote:

>> Hello Helen,
>> At 27.04.2005 14:27, you wrote:
>> > At 01:46 PM 27/04/2005 +0600, you wrote:
>> >>Hi All,
>> >>
>> >>I have users with read only permission on some tables by PUBLIC user.
>> >>
>> >>And I have users with full access to table.
>> >>(OPERATORS is a role)
>> >>
>> >>When read-only user execute statement for example "select
>> MYTABLE_ID from
>> >>from any database tool it's ok! Whey allow him to select records from
>> >>the table and just disallow to edit or insert the table.
>> >>
>> >>With IBO I found little problem.
>> >>Wnen statement "select MYTABLE_ID from MYTABLE" assigned to IB_Query
>> >>and EditSQL property present with my custom update statement
>> >>i recieve "no permission for update/write access to column MYTABLE_ID"
>> >>on IB_Query.Open.
>> >>No one try to edit any records.
>> >>When I clear EditSQL before IB_Query.Open it's work fine.
>> >>RequestLive, ReadOnly and PreventEditing properties can't help in this
>> >>case.
>> >>
>> >>I understand I, can leave out what problem by clearing EditSQL property
>> >>in all my IB_Queries when user role is not OPERATORS.
>> >>But I think it isn't best way.
>> >>
>> >>Please consider this strange behavior.
>> > It is not strange behaviour at all. By making a dataset "live" you are
>> > telling the system that the logged-in user is to have the
>> rights to write
>> > to the table. IBO correctly refuses to allow the non-privileged user to
>> > access the set as a live set.
>> > You can safely put your custom EditSQL, InsertSQL and DeleteSQL
>> back. What
>> > you should do instead is to check the user privileges at
>> connect time and
>> > set a flag indicating whether the role has the needed
>> privileges. When the
>> > dataset is created, check this flag and set RequestLive accordingly. If
>> > RequestLive is False, the I/U/D buttons on the UpdateBar will
>> be disabled
>> > automatically.
>> > Helen
>> I wrote:
>> "RequestLive, ReadOnly and PreventEditing properties can't help
>> in this case."
>> RequestLive is False
>> ReadOnly is True
>> PreventEditing is True
>> Any values combination all of them gives error, if assigned
>> EditSQL and user
>> don't has permission.
>> What's the problem!
>> Anyway, let suppose what user has permission to delete records
>> but hasn't permission to edit them.
>> RequestLive I MUST set to True.
>> Why I get "no permission for update/write access to column ......"
>> error when I even don't dare to edit something.
>> Ramil

> Yes - I know this issue well. You have to clear the custom update SQL. IBO
> tries to prepare the statements even when requestlive of false.. Clear them
> and it's fine
> Alan

Thank you for precise answer.
I'm already solve it by EditSQL.Clear;