Subject Re: Prepare in IBquery - TO Helen
Author Marcilio Soares
Then my problem not have soluction.
Tank's Helen.
Valeu!


--- In IBObjects@egroups.com, Helen Borrie <helebor@w...> wrote:
>
> Marcilio,
>
> A datasource does not have privileges. If you want your user to be
able
> run an application that performs an update, you must grant update
> privileges to that user.
>
> If you want your application to be read-only, then set all of the
datasets
> to be read-only and RequestLive=False, and do not add any editsql.
>
> Helen
>
>
> At 05:31 PM 21-12-00 +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 and i'm using
> >a datasource linking with IB_Query.When delete datasource execute
> >nomality, but with it i see error message.I have the datasource
> >because it premission access to IB_edit.
> >
> >
> >--- Em IBObjects@egroups.com, "Marcilio Soares"
> ><marcilio.soares@b...> escreveu
> > > 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
> > > > _______________________________________________________
> >
> >
> >
>
> All for Open and Open for All
> InterBase Developer Initiative · http://www.interbase2000.org
> _______________________________________________________