20080612 purging a user from wwsec_person - plembo/onemoretech GitHub Wiki

title: Purging a user from wwsec_person$ link: https://onemoretech.wordpress.com/2008/06/12/purging-a-user-from-wwsec_person/ author: lembobro description: post_id: 501 created: 2008/06/12 18:30:09 created_gmt: 2008/06/12 18:30:09 comment_status: open post_name: purging-a-user-from-wwsec_person status: publish post_type: post

Purging a user from wwsec_person$

My apologies to anyone who never has to work with Oracle 10g AS Portal.

User gets a WWC-41742 error when trying to log into Portal.

Like most things the solution is to purge him from the wwsec_person$ table.

Use sqlplus to log into the database as the PORTAL user (if you can’t find the password for this, you don’t deserve to be an OID admin).

Then do a

delete from wwsec_person$ where USER_NAME = '[user's ID]';

and then a

commit;

The user should now be able to log in.