Finding and Updating the GUID of a User in Oracle Application Server

1) Finding the GUID of a User

a. Using SQL
SQL> select guid from portal.wwsec_person$ where user_name = ‘<user_name>’;
b. Using ldapsearch:
ldapsearch -h myhost -p 3060 -D cn=orcladmin -w <GUI_password_for_orcladmin_user> -b “” -s sub “cn=<cn_for_problem_user>” “*” orclguid

2) Manually updating a users GUID
SQL> update portal.wwsec_person$ set guid = <OID_user_GUID> where user_name =’user_name’;
SQL> commit;