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
_______________________________________________________