Hi Mark, Thanks for your reply! I always remove the permissions when people leave the organization. I thought there was a way to remove their IDs as well but I guess it is better to keep them in the system. Maybe this can added as a new feature in future DSpace releases? No? Thanks again.
Thanks to Jose and Monica who also replied. Fang Wang Digital Information Management Librarian Texas Tech University School of Law Library 1802 Hartford Ave, Lubbock, TX 79409 806-742-3990 ext. 290 [email protected]<mailto:[email protected]> "Real knowledge is to know the extent of one's ignorance." -Confucius [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of Mark Diggory Sent: Saturday, April 21, 2012 11:23 AM To: Blanco, Jose Cc: Wang, Fang; [email protected] Subject: Re: [Dspace-general] Delete E-persons who have submitted items to DSpace Fang, This is not the right direction, altering the eperson2group relationship will not impact this foreign key constraint. The Eperson is set as the owner in the Item record they submitted. This is the constraint and its in the item table. Its generally better to just disable the login of the eperson. For database integrity and expected behavior of DSpace I don't recommend removing the user. Mark On Fri, Apr 20, 2012 at 8:16 AM, Blanco, Jose <[email protected]<mailto:[email protected]>> wrote: That table is part of the dspace installation, you would need to find the server where the postgres db is install and connect to it to query it and issue sql commands to it. The person that got your instance going should be able to do that. -Jose From: Wang, Fang [mailto:[email protected]<mailto:[email protected]>] Sent: Friday, April 20, 2012 11:15 AM To: Blanco, Jose; [email protected]<mailto:[email protected]> Subject: RE: [Dspace-general] Delete E-persons who have submitted items to DSpace Where is that epersongroup2eperson table located? I can only access and manage the front end of DSpace. Fang Wang Digital Information Management Librarian Texas Tech University School of Law Library 1802 Hartford Ave, Lubbock, TX 79409 806-742-3990 ext. 290<tel:806-742-3990%20ext.%20290> [email protected]<mailto:[email protected]> "Real knowledge is to know the extent of one's ignorance." -Confucius From: Blanco, Jose [mailto:[email protected]<mailto:[email protected]>] Sent: Friday, April 20, 2012 10:10 AM To: Wang, Fang; [email protected]<mailto:[email protected]> Subject: RE: [Dspace-general] Delete E-persons who have submitted items to DSpace So that person’s eperson_id does not exists in epersongroup2eperson table? From: Wang, Fang [mailto:[email protected]]<mailto:[mailto:[email protected]]> Sent: Friday, April 20, 2012 11:06 AM To: Blanco, Jose; [email protected]<mailto:[email protected]> Subject: RE: [Dspace-general] Delete E-persons who have submitted items to DSpace Hi Jose, Thanks for your reply! I did make sure to remove the submitters from the groups they belonged to. Now they only belong to anonymous but I still cannot delete them… Fang Wang Digital Information Management Librarian Texas Tech University School of Law Library 1802 Hartford Ave, Lubbock, TX 79409 806-742-3990 ext. 290<tel:806-742-3990%20ext.%20290> [email protected]<mailto:[email protected]> "Real knowledge is to know the extent of one's ignorance." -Confucius From: Blanco, Jose [mailto:[email protected]]<mailto:[mailto:[email protected]]> Sent: Friday, April 20, 2012 10:01 AM To: Wang, Fang; [email protected]<mailto:[email protected]> Subject: RE: [Dspace-general] Delete E-persons who have submitted items to DSpace I’m not sure this is the right answer to your question, but I suspect you still have that person assigned as a submitter to some collection, so get rid of them from that group, and then try to delete that eperson. -Jose From: Wang, Fang [mailto:[email protected]]<mailto:[mailto:[email protected]]> Sent: Friday, April 20, 2012 10:56 AM To: [email protected]<mailto:[email protected]> Subject: [Dspace-general] Delete E-persons who have submitted items to DSpace Hi All, I am sorry if this question has been asked a million times. Is there a way to delete E-persons who have submitted items to DSpace? It doesn’t seem like I have that option under the E-person Management tool when logged in as admin. I could delete any regular users but not the ones who were submitters before. I did search the archives of the DSpace mailinglist. Someone asked this question back in 2004 but there was no answer to his question. I’d appreciate it if you could offer any help. Thank you so much! Fang Wang Digital Information Management Librarian Texas Tech University School of Law Library 1802 Hartford Ave, Lubbock, TX 79409 806-742-3990 ext. 290<tel:806-742-3990%20ext.%20290> [email protected]<mailto:[email protected]> "Real knowledge is to know the extent of one's ignorance." -Confucius ------------------------------------------------------------------------------ For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 _______________________________________________ Dspace-general mailing list [email protected]<mailto:[email protected]> https://lists.sourceforge.net/lists/listinfo/dspace-general -- [http://atmire.com/images/@mire_web_2.jpg] Mark Diggory (Schedule a Meeting<https://tungle.me/markdiggory>) 2888 Loker Avenue East, Suite 305, Carlsbad, CA. 92010 Esperantolaan 4, Heverlee 3001, Belgium http://www.atmire.com<http://www.atmire.com/>
<<inline: image001.png>>
------------------------------------------------------------------------------ For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________ Dspace-general mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-general
