On our system we have certain tables in one of our main databases that are associated with "data capture" and full-row logging (a.k.a., "log snooping").
The "cdc_set_fullrowlogging" command can be used to either enable full-row logging or disable full-row logging. My experience has been that only the "informix" user can successfully run this command. If we have another user on the same database that has DBA permissions, then even if that user can create tables, etc., it cannot successfully run this "cdc_set_fullrowlogging" command. Does anyone have an insight on why this is true or how to overcome this problem?
Here is a link that describes this command:
John Dargan, Database Administrator II - Information Technology
LAURA E. ROTH, Clerk of the Circuit Court
Seventh Circuit, Volusia County, Florida
I would expect the users in the DBSA group to be able to run the command. If that is not the case then I would raise a PMR to double check whether it should work or not