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
> > _______________________________________________________