Subject | Problem With IB_Query |
---|---|
Author | Ahmet Elgin |
Post date | 2005-07-29T17:14:07Z |
Hello all.
I have a problem with IB_Query. A user have only select privilege to a
table. I use IB_Query's generate for table function and it creates a
statement like this:
UPDATE table SET
CODE = :CODE, /*PK*/
DESC = :DESC
WHERE
CODE = :OLD_CODE
INSERT INTO table(
CODE, /*PK*/
DESC)
VALUES (
:CODE,
:DESC)
DELETE FROM table
WHERE
CODE = :OLD_CODE
everthing ok, but when a user with only select privilege opens the form,
an error occurs " no permission for update/write access to table". User
is not trying to update records just selecting.
If I set SQL statement "select * from table for update" and don't set
any EditSQL, UpdateSQL or DeleteSQL no problem occurs. and user can see
the records. Why this happens? do I have to do someting special?
Thanks for your help...
Ahmet ELGIN
I have a problem with IB_Query. A user have only select privilege to a
table. I use IB_Query's generate for table function and it creates a
statement like this:
UPDATE table SET
CODE = :CODE, /*PK*/
DESC = :DESC
WHERE
CODE = :OLD_CODE
INSERT INTO table(
CODE, /*PK*/
DESC)
VALUES (
:CODE,
:DESC)
DELETE FROM table
WHERE
CODE = :OLD_CODE
everthing ok, but when a user with only select privilege opens the form,
an error occurs " no permission for update/write access to table". User
is not trying to update records just selecting.
If I set SQL statement "select * from table for update" and don't set
any EditSQL, UpdateSQL or DeleteSQL no problem occurs. and user can see
the records. Why this happens? do I have to do someting special?
Thanks for your help...
Ahmet ELGIN