Re: Informix/PeopleSoft Question.

Posted in 1998

jbennett — 6 Mar 1998 12:01:00 -0700 — source: Informix-list mailing list archive (1991-1998)

DUDE....can you find the table/fields and do a sql for this task.. we have ps/informix too but i have not hit this yet.... In article <6dh51l$4p0$1@news.xmission.com>, Abhay Mannur <amannur@spf.fairchildsemi.com> writes: > > Hi All, > Environment : Informix 7.22 and 7.23 > PeopleSoft 7.0 > Whenever we want to change a DB owner, we export the database and > edit the schema file (dbname.sql) > After importing again, we change 3 PeopleSoft specific tables : > psdbowner, pslock and psoperdefn out of which the first table is ownd > by PS and the other two are owned by dbowner of the database. > Is there any way to do this without export/import which is time > consuming. Can I update system catalog tables to do this and is this > advisable ? > > Thanks in advance. > Abhay.