Deleting a user/group is not propagated in r_objt_access table

[Stoica, S.]

Hello,

We have noticed that when a group / user is deleted, the entries in the table r_objt_access in the icat associated with that user/group are not removed from the database.

This means that an iquest like the one below form will also retrieve the entries of the removed users/groups.

iiquest "SELECT COLL_NAME, COLL_ACCESS_USER_ID, COLL_ACCESS_NAME, COLL_ACCESS_TYPE WHERE COLL_NAME = '/zone/home/user/a_folder'"

Question 1:
Should the deletion of the user not cascade to the r_objt_access table as well?

Question 2:
Is it safe to remove these leftover entries, to clean the database? 

Thanks in advance!
Simona

--

Dr. Simona Stoica

Software Developer CIT

[Terrell Russell]

Hi Simona,

This was closed less than two weeks ago and included in 4-3-stable and will be included in 4.3.4.

   https://github.com/irods/irods/issues/7778

Q1 - Yes, please see the issue and associated commit to confirm the cascading delete is now correct.

Q2 - And yes, it is safe to remove any leftover entries today.  Please consider sharing any SQL you may have to find (and potentially remove) any leftovers today.

Terrell

--
--
The Integrated Rule-Oriented Data System (iRODS) - https://irods.org
 
iROD-Chat: http://groups.google.com/group/iROD-Chat
---
You received this message because you are subscribed to the Google Groups "iRODS-Chat" group.
To unsubscribe from this group and stop receiving emails from it, send an email to irod-chat+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/irod-chat/CAMzuf4yuhY97-ZeD8%3DWt1N5rpaMoqPpNcvszSWkC6wtXLv379w%40mail.gmail.com.