Description You can’t remember the password for the Portal Security Officer (PSO).
Solution Issue this SQL call in the Adaptive Server Enterprise entldb database to reset the PSO password to “123qwe”:
UPDATE Subject
SET EncodedPassword="{SHA:DktKCZJELMc=}OC0GOj+HRsPb6ZweCt3/NaKmagM="
WHERE SubjectDN LIKE "%uid=pso%"
If the account is locked due to repeated invalid login attempts, remove the login lock record for the PSO user in the LoginLock table.
If you are using Adaptive Server Anywhere, see the ASA
Database Administration Guide for instructions.