delete user accounts from DB

Matt Ragland shared this question ago

Answered

I'm resurrecting an old thread. I've created several thousand users in the yellowfin database. Many of which I now wish to remove. I've already deleted the users using the webservices api, but the users still exist in the database. I found this thread which mentions steps for removing them. Can someone at yellowfin provide me which tables I must clean up:

https://www.yellowfinbi.com/resources/forum/yfforum-delete-account-from-db-thread-131174

The same question

Replies (3)

Eric Hagfors ●

Hi Matt,

Thanks for reaching out. i was able to find this in a previous ticket - this looks correct, however this type of activity is out of scope for support technically so please have working backups before attempting anything like this.

First, be very very careful with these statements. Second, always back-up your stuff.

SQL queries for clearing orphaned users.

delete from Person where IpPerson in (select distinct ipchild from IpRltshp ip where ip.endreasoncode = 'DELETED')

delete from IpClass where IpId in (select distinct ipchild from IpRltshp ip where ip.endreasoncode = 'DELETED')

delete from IpContact where IpId in (select distinct ipchild from IpRltshp ip where ip.endreasoncode = 'DELETED')

delete from StaffMemberRole where IpEmployee in (select distinct ipchild from IpRltshp ip where ip.endreasoncode = 'DELETED')

delete from IpRltshp where EndReasonCode = 'DELETED'

I could make this into a developer request if you'd like to have an option to "fully" remove users like this built into a future version officially, just let me know.

Thanks,

Eric

Hi Matt,

First, be very very careful with these statements. Second, always back-up your stuff.

SQL queries for clearing orphaned users.

delete from Person where IpPerson in (select distinct ipchild from IpRltshp ip where ip.endreasoncode = 'DELETED')

delete from IpClass where IpId in (select distinct ipchild from IpRltshp ip where ip.endreasoncode = 'DELETED')

delete from IpContact where IpId in (select distinct ipchild from IpRltshp ip where ip.endreasoncode = 'DELETED')

delete from StaffMemberRole where IpEmployee in (select distinct ipchild from IpRltshp ip where ip.endreasoncode = 'DELETED')

delete from IpRltshp where EndReasonCode = 'DELETED'

I could make this into a developer request if you'd like to have an option to "fully" remove users like this built into a future version officially, just let me know.

Thanks,

Eric

Reply URL

Eric Hagfors ●

Hi Matt,

Just wanted to check in to see if you had a chance to review my reply at this time.

Thanks,

Eric

Reply URL

Eric Hagfors ●

Hi Matt,

I'm going to go ahead and mark this question as Answered at this time. Feel welcome to reach out in the future.

Thanks,

Eric

Reply URL