We've been working on a JDBC Oracle driver using views, we can sync user
successfully. However when we are also trying to sync group memberships
using views without any success . We have the following views:

-- User View
CREATE VIEW
IDM_VIEW_TGEUSUARIO ( PK_CD_USUARIO, NM_USUARIO, CD_LOGIN, CD_SENHA,
IN_BLOQUEIO, DT_EXPIRACAO, DT_ATUALIZA, CD_USURSP, CD_EMPRESA,
DT_ACESSO, CD_EMAIL ) AS
SELECT
CD_USUARIO,
NM_USUARIO,
CD_LOGIN,
CD_SENHA,
IN_BLOQUEIO,
DT_EXPIRACAO,
DT_ATUALIZA,
CD_USURSP,
CD_EMPRESA,
DT_ACESSO,
CD_EMAIL
FROM
VotoSinawin.TGEUSUARIO

--User-Group view
CREATE VIEW
IDM_VIEW_TCAUSUGRP ( PK_CD_GRUPO, FK__CD_USUARIO__CD_USUARIO ) AS
SELECT
CD_GRUPO,
CD_USUARIO
FROM
VotoCorrwin.TCAUSUGRP

When we try to do an
do-add-dest-attr-value("IDM_SINACOR.IDM_VIEW_TCAUSUGRP",when="after ",token-local-variable("codGroup"))
it seems that the driver is trying to add it into IDM_VIEW_TGEUSUARIO
view since it returns the following warning:

Status: Warning
Message: Column 'PK_CD_GRUPO' is undefined on table/view
'IDM_SINACOR.IDM_VIEW_TGEUSUARIO' or is unsyncable.

And no changes are made in the DB.

We've also tried do-add-dest-attr-value("Group
Membership",when="after",token-local-variable("codGroup")) with the
following schema mapping:

<attr-name class-name="User">
<nds-name>Group Membership</nds-name>
<app-name>IDM_VIEW_TCAUSUGRP.PK_CD_GRUPO</app-name>

And we received the same behaviour.

Any ideas?

Thanks in advance


--
mmarchese
------------------------------------------------------------------------
mmarchese's Profile: https://forums.netiq.com/member.php?userid=1311
View this thread: https://forums.netiq.com/showthread.php?t=46340