Restore Deleted User profile : PS

while installing peoplesoft  i issued a command by mistake..

Drop user PS cascade;

its deleted all the chain records..

to restore PS user again,

for eg SYSADM/SYSADM

run the script @/script/nt/dbowner.sql;


login to datamover as SYSADM/SYSADM run the following script

INSERT INTO PS.PSDBOWNER VALUES('HRDEMO', 'SYSADM');
UPDATE PSSTATUS SET OWNERID = 'SYSADM';
UPDATE PSOPRDEFN SET SYMBOLICID = 'SYSADM1', OPERPSWD = OPRID, ENCRYPTED = 0;
UPDATE PSACCESSPRFL SET ACCESSID = 'SYSADM', SYMBOLICID = 'SYSADM1', ACCESSPSWD = 'SYSADM', VERSION = 0, ENCRYPTED = 0;


ENCRYPT_PASSWORD *;


TON!!!!