How can we uncorrelate an account from user?

[Sampsa]

Hi,

How can we uncorrelate accounts from a user? This has been asked before but this suggestion here does not work: https://forums.saviynt.com/t5/identity-governance/how-to-uncorrelate-an-account-from-user/m-p/22550

I can use a csv import to change the correlated user, but using an empty username in the import does nothing. The correlation stays the same.

[Darshanjain]

Hi @Sampsa 

Yes as you said you can use csv option but username if blank it wont take action but if you keep other username then it will change it.

Now if you want to make the account as orphan, then only option is to use custom query job and update user_accounts table ( you can make the userkey as null or put some value which shouldnt be a valid userkey ) then it will uncorrelate the accounts.

Thanks

Darshan

[Sampsa]

Hi,

I tested using a customqueryjob. The userkey in the user_accounts table is set as not nullable and it's also a key value that cannot be set to an invalid value.

[Darshanjain]

Yes, in the new version there is  foreign key check to userkey from users table.

You can raise this in ideas portal to get this feature.

For now the only way is to create one user and assign all orphan accounts to that user.

Thanks

Darshan