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