Re: Transaction Logging and table ownership

Terron Wright wrote: > > When I turn transaction loggin on to unbuffered or ansi using ontape it > changes the ownership of all of the tables to DBA. I would like to be > able to change my buffered status without changing the ownership of the > tables. Does anyone have a solution. Hi Terron ! Are you sure that the ownership of your tables changed ? Which user has created the tables ? By default, there is no user dba. The default dba user is usually informix. In ANSI databases there is an important difference concerning table names compared to Non-ANSI databases. A table is uniquely identified only by user.tablename. The name of the table is not enough. I hopy my hint points to the right direction. Tschuess, Dirk -- --------------------------------------------------- Dirk Schmidtpott S I E M E N S EMail: schmidtpott.pad@sni.de ============= Phone: 0049-5251-8-14922 N I X D O R F Fax : 0049-5251-8-27905 The above statements and opinions are my own and do not necessarily represent those of my employer. ---------------------------------------------------