Re: SE: Can't drop transaction logging

Richard Spitz writes: |> In a SE 4.1 database, I just discovered that the person who created |> it used only a relative pathname for the transaction log file. This |> makes it impossible to access the database from other directories. |> |> 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". Run the update as user informix. Dave Disclaimer: The opinions expressed in this message are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. **************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney