Subject | table access rights |
---|---|
Author | Rick Roen |
Post date | 2006-01-16T11:26:42Z |
D7 IBO4.5B FB1.5
I'm getting ready to deploy some new software and have a question
about table access rights in TIB_Query components (and related
components like TIB_Cursor).
Say I have a "CUSTOMER" table with the following setup:
SQL: Select * from CUSTOMER order by NAME
EditSQL: Update CUSTOMER ...
InsertSQL: Insert into CUSTOMER ...
DeleteSQL: Delete from CUSTOMER...
If I log into the DB as a user who is allowed Edit, Insert and
Delete rights there is no problem. If the user does not have rights
I get a GDS error 335544352 "no permission to update/write". I think
IBO is preparing the EditSQL and others which triggers this error.
I tried to set the TIB_Query with PreventEditing = True etc. and
even setting ReadOnly = True, but neither stopped IBO from preparing
the statements.
If I delete the EditSQL etc. statement before opening the table
there is no problem since there is nothing to prepare.
Is this what I have to do, or is there a better way to manage user
access?
TIA
Rick
I'm getting ready to deploy some new software and have a question
about table access rights in TIB_Query components (and related
components like TIB_Cursor).
Say I have a "CUSTOMER" table with the following setup:
SQL: Select * from CUSTOMER order by NAME
EditSQL: Update CUSTOMER ...
InsertSQL: Insert into CUSTOMER ...
DeleteSQL: Delete from CUSTOMER...
If I log into the DB as a user who is allowed Edit, Insert and
Delete rights there is no problem. If the user does not have rights
I get a GDS error 335544352 "no permission to update/write". I think
IBO is preparing the EditSQL and others which triggers this error.
I tried to set the TIB_Query with PreventEditing = True etc. and
even setting ReadOnly = True, but neither stopped IBO from preparing
the statements.
If I delete the EditSQL etc. statement before opening the table
there is no problem since there is nothing to prepare.
Is this what I have to do, or is there a better way to manage user
access?
TIA
Rick