How to DELETE data from a table[Ingress db]

Asked Jan 23 '18 at 17:19

Active Jan 23 '18 at 17:19

Viewed 132 times

I need to delete certain data from my table,
but I write the following:

delete from myTable where myField = value;
commit;

and I get error:

E_US0DAE DELETE on Table myTable: no GRANT or GRANT compatible permit exists.

Does anyone know why that error comes out?
I hope you can help me.

asked Jan 23 '18 at 17:19

BrandCodes

1

You do not have the permission to Delete, your user login needs permission granted for delete. – Ryan Wilson Jan 23 '18 at 17:24
@RyanWilson its right. I just changed my user, which has permissions. – BrandCodes Jan 23 '18 at 18:06
ok. Does that mean you can delete from the table now? – Ryan Wilson Jan 23 '18 at 18:35
yes, I can already make changes to the db. – BrandCodes Jan 24 '18 at 15:07

0 Answers0