I would make additional user authorization for some UserDefinedTable (UDT).
I have no problem in doing it by hand. Now I would try to automate this stuff.
Suppose I have an UDT called TRUCKS (belongs to @TRACKS table).
When I open the UDT form, I can read the Form Type. Suppose the FormType is '11005'.
Yes, of course, If I make this table on a new company most likely the FormType changes.
I have done a little test.
SELECT TblNum FROM OUTB WHERE TableName = 'TRUCKS';
On a system where the FormType is '11005' the query returns 5.
On a system where the FormType is '11011' the query returns 11.
So I can automate the process by retrieving the TblNum, add it to 11000 and cast it as string.
It is correct this method or I can't make assumption about the FormType of UDT?
Thanks in advance.