OID table stores account attributes

This table stores all users attributes that have been imported into OID.
ODS.DS_ATTRSTORE
The password for ODS in OID 10g should be same as the orcladmin password.
The password for ODS in OID 11g is the one you entered when you create the OID database.

here is an example:

select * from ODS.DS_ATTRSTORE where entryid in (
select entryid from ODS.DS_ATTRSTORE
where attrname='uid'
and UPPER (attrval) = upper('&user_name'));