Sorry, sorry! Again the above in english!!!

[Quoted] does anyone has a clue, how to solve the following problem?

I created a view over three tables. With a 'grant select ...' i give other
users access to the view.
In my Forms6.0 application I a block is based on that view. In a procedure I give a default where to this block and then do an execute_query. When it's me who is connected to the database, the Forms application works fine. If someone else is trying to start the application then the execute_query causes an Error: 'unable to perform query'. Pressing 'Shift-F1' shows: 'ivalid column'. The only invalid column I can see in this automatically generated query is ROWID. Only the where-clause is from me.

I tested with SQL*Plus:
Me and everybody else can do a 'Select *' for this view. Me and everybody else cannot do a 'Select rowid' for this view.

Even though the application works fine for me. I'd like the apllication to run for everybody else, too, without having everybody to create this view himself.

Can I somehow get rid of this rowid in automatic generated queries? Any other suggestions?

Thank you very much for your help!
Gudrun Janssen Received on Tue Feb 22 2000 - 16:02:21 CET