Re: SE: Can't drop transaction logging

Richard Spitz writes: ->... ->I wanted to change that following the description in the 4.0 SQL manual. ->I logged in as the DBA for that database and tried to issue the ->following SQL command: -> ->DELETE FROM systables WHERE tabname = "syslog" -> ->This produces an error "No delete privilege". -> ->What's going on here? Is there a possibility how I can drop transaction ->logging on this NON-ANSI SE database in 4.1? Richard, Log on as user Informix and issue the command. I've always used the following command instead, but I imagine either will work: delete from systables where tabid = "L" ->| Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | Regards, - Cathy -------------------------------------------------------------------------------- Cathy Kipp ckipp@vth1.vth.colostate.edu Veterinary Teaching Hospital Phone: (303) 491-1294 Colorado State University Fax: (303) 491-1205 -------------------------------------------------------------------------------- Disclaimer:These are my opinions and may not represent anything at all relevant.