Subject Re: Prepare in IBquery - Help me!!!!
Author Marcilio Soares
My system have user and privs with select and select/update.
I not try update a table but the IB_query execute a prepare update.

--- Em IBObjects@egroups.com, Svein Erling Tysvær
<svein.erling.tysvaer@k...> escreveu
> Of course you get an error message if you try to update a table
without
> update/write access!
>
> What do you expect to happen?
>
> Set
>
> At 14:30 21.12.2000 -0000, you wrote:
> >Helen,
> >there is message:
> >
> >ISC ERROR CODE:335544352
> >
> >ISC ERROR MESSAGE:
> >no permission for update/write access to table NOMES
> >
> >STATEMENT:
> >TIB_Cursor: "frmWISQL.crEdit"
> >
> >I'm using the IB_Wisql with Cursor|sql page:
> >UPDATE NOMES SET
> >ID=:ID,
> >NOME=:NOME,
> >DATA=:DATA
> >WHERE ID=:ID
> >
> >The user have only grant select in the table NOMES.
> >
> >
> >--- Em IBObjects@egroups.com, Helen Borrie <helebor@w...> escreveu
> >> At 12:31 PM 21-12-00 +0000, you wrote:
> >> >I try but IB_Query show me the msg "no permission...bla bla"
> >> >Help me!!!!
> >>
> >> Calm down....this message means what it says - you have have no
> >permissions
> >> for this table.
> >>
> >> Let's do a bit of even-headed testing here.
> >>
> >> Get a copy of IB_WISQL.exe from the Downloads page of
> >www.ibobjects.com
> >>
> >> Connect to the database using the SAME username, password and
path
> >that you
> >> used in your application.
> >>
> >> Copy the SQL from your IB_Query and submit it on the Cursor |
SQL
> >page of
> >> IB_Wisql.
> >>
> >> Click the Prepare button.
> >>
> >> If there is no error message, click the blue book button to
fetch
> >the dataset.
> >>
> >> Click the 'Last' button to fetch all the rows (this is the >|
> >button on the
> >> navigation bar).
> >>
> >>
> >> Report back to the list what you see.
> >>
> >> You might also get some useful information by activating the
> >Monitor dialog
> >> in IB_WISQL and watching what is going to the server.
> >>
> >> Helen
> >>
> >> All for Open and Open for All
> >> InterBase Developer Initiative · http://www.interbase2000.org
> >> _______________________________________________________
> >
> >
> >
> >
> >
> >