smartquerry read only

sbslavonac · Post by **sbslavonac** » Tue 12 Jun 2007 09:29

After installing version 6.05, all queries are set to read only when user connect.
I can work normally but useres keep getting read only error when trying to modify records.
Has anything changed on user rigths in 6.05
Boris

Plash · Post by **Plash** » Wed 13 Jun 2007 07:45

We could not reproduce the problem. Please describe the problem more detailed. Specify the SQL text for the TSmartQuery component that is read-only, and the script to create tables used in the query.

sbslavonac · Post by **sbslavonac** » Sat 21 Jul 2007 11:09

Plash wrote:We could not reproduce the problem. Please describe the problem more detailed. Specify the SQL text for the TSmartQuery component that is read-only, and the script to create tables used in the query.

Found what was changed.
Select statment on table with no primary key
Select rowid, t.* from test_data

and using ROWID for insert, update... switches querry to readonly if user is not shema owner

while
Select t.rowid, t.* from test_data
work normaly for all users

Plash · Post by **Plash** » Mon 23 Jul 2007 07:34

You should set the SetFieldsReadOnly option of the TSmartQuery component to False.

Plash · Post by **Plash** » Mon 23 Jul 2007 08:59

Please describe also how are you changing the current schema, and specify whether you open some queries before changing the schema. This information should help us to reproduce the problem.

jfudickar · Post by **jfudickar** » Mon 23 Jul 2007 10:41

In my scenario the following query is readonly

Code: Select all

SELECT  V.*, ROWID
  FROM  SYST_PARAM_VALUE V

And this is readwrite :

Code: Select all

SELECT  V.*, ROWID
  FROM  systools.SYST_PARAM_VALUE V

I'm connecting with a different user then systools. And SYST_PARAM_VALUE is a public synonym.

All based on 6.10.

Any ideas?

Greetings
Jens

Plash · Post by **Plash** » Tue 24 Jul 2007 08:37

We have fixed this problem. The fix will be included in the next build of ODAC.

jfudickar · Post by **jfudickar** » Tue 24 Jul 2007 11:48

Can you send me the fix by mail.

I have the component source.

Greetings and thanks
Jens

Plash · Post by **Plash** » Tue 24 Jul 2007 12:28

We have sent the fix to your e-mail.