Oracle
Building a File with Create RRNO Column selected
For Oracle, in addition to having permission to alter the table, you require permission to create a sequence and a trigger as the table owner.
Removing X_UPID and X_RRNO Columns
For Oracle, if you remove the columns, you should also remove the trigger and the sequence. Use the Oracle data dictionary views DBA_TRIGGERS and DBA_SEQUENCES (or USER_TRIGGERS and USER_SEQUENCES when you are logged on as the table owner) to find the trigger and sequence to be dropped. (The object names will contain the LANSA file name.)
Also See