Error when running sql query to delete and update UD02

Kinetic ERP
1

I am trying to run the below sql query Microsoft Sql Management Studio in a Kinetic database and getting the error below. I did it all the time in ERP10. Please help !!!
Thanks,
Richard

delete from ice.ud02 where company = ‘jms’
insert into ice.ud02(company,key1,key2)
select ‘jms’,‘projcost’,projectid
from erp.Project
select * from ice.ud02

Msg 229, Level 14, State 5, Line 1
The DELETE permission was denied on the object ‘UD02’, database ‘ERP11Live’, schema ‘Ice’.
Msg 229, Level 14, State 5, Line 2
The INSERT permission was denied on the object ‘UD02’, database ‘ERP11Live’, schema ‘Ice’.

2

Looks like someone has security set up to prevent this type of direct access.

I would create a spreadsheet and use DMT to remove the records you are wanting to remove.

1 Like
3

The DMT is best - you want to be careful with the UD tables. If you delete/drop the entire table from your database you won’t be able to reuse it. There are built in business objects for binding data to forms, retrieving data in BAQs that won’t work if you drop/delete a table.

4

Time to unlearn those bad habits…

1 Like
5

This should be fairly clean in an ubaq or a function. Here are a couple of threads. the first one is on clearing out a ud and the second is one of many where @timshuwy shows how to use UpdateExt.

1 Like