Permission problem with "insert" query

sylvain_pa...@my-deja.com

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Permission problem with "insert" query

Hello,

My problem is really simple, I hope the solution too...
My Delphi program execute the following query to an interbase DB :
insert into mytable values('something')
Everything seems okay but when executing : "insuffisant permissions to
execute the query. No permission for insert/write access to table
mytable".
I've granted mytable with ALL privileges (grant all on mytable to xxx),
but nothing has changed. Did I forget something ?

Regards,

Sylvain

Sent via Deja.com http://www.deja.com/
Before you buy.

Sunbo

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Permission problem with "insert" query

You not login database by owner idintify (who creates the TABLE).
Please add your login user with IB Server Manager.

Quote

> My problem is really simple, I hope the solution too...
> My Delphi program execute the following query to an interbase DB :
> insert into mytable values('something')
> Everything seems okay but when executing : "insuffisant permissions to
> execute the query. No permission for insert/write access to table
> mytable".
> I've granted mytable with ALL privileges (grant all on mytable to xxx),
> but nothing has changed. Did I forget something ?

Other Threads

1. Perplexing "permission denied" problem

2. The keys "-"/"+"/"*"

3. "SQL Query problems!!"

4. Problem with "group by" in query

5. "Long query" problem

6. ""256 Color Mouse""

7. How to initialize "Text"-Property without raising "OnChange"-event

8. How to initialize a "Text"-property without raising an "OnChange"-event

9. joker char "*", "%"

10. Question about "TBandForm","TDeskBandInfo"?