Very interesting!     And completely confusing.     What I think you are 
saying is that it is possible to delete the GROUP, but meanwhile all the actual 
permissions are still in the system?

  When evergreen was started, it has two main permission groups.    Patrons and 
Users.    Our patrons group is still there, but the whole group of Users is 
gone and as far as I can tell, so are the actual permission profiles that were 
under that group.    Cataloger, Catalog Administrator, Circulation 
Administrator, Systems Administrator, etc.    

 It would seem to me that what you are saying makes sense, that of course you 
cannot delete the actual permission profile if there are users attached to that 
profile.   But is it possible to delete the whole group AND all the permission 
profiles underneath can go away?



-----Original Message-----
From: Open-ils-general 
[] On Behalf Of Thomas 
Sent: Tuesday, July 05, 2016 12:14 PM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] All permission groups deleted?

All the permission assignments are in the database, not the file system.

Taking a very quick look it appears that deleting a group assigned directly to 
a user should fail due to key constraints, but deleting a group only assigned 
to users as a secondary mapping (permission.usr_grp_map table) would be 

Thus, in addition to getting your missing rows out of the permission.grp_tree 
table you would need to get the missing permission.grp_perm_map entries and 
permission.usr_grp_map entries.

If your permissions are still working, though, I would instead assume that 
something happened to make them not show up where you expect them. Have you 
checked at the database level to see that they are, in fact, gone, and it isn't 
just that permission to touch those groups isn't assigned properly?

Thomas Berezansky
Assistant Network Administrator
Merrimack Valley Library Consortium
4 High ST, Suite 175
North Andover, MA 01845
Phone: 978-557-8161

-----Original Message-----
From: Open-ils-general 
[] On Behalf Of Walz, 
Sent: Tuesday, July 05, 2016 11:54
To: Evergreen Discussion Group <>
Subject: [OPEN-ILS-GENERAL] All permission groups deleted?

All –


So, what happens when all the staff permission groups are deleted?    How is it 
that people can still login to the system?   Staff with “cataloger” permissions 
and “circ” permissions and so forth?   What happens when they try to login with 
that account?   Does evergreen ‘assign’ them some other type of permission?     
Our patron permissions group is fine.   Our staff group got obliterated.  


And how do you get the permissions all back?    We have the server backed up.  
Where do these reside and can you copy them back onto the current working 
server?   File location?  





Jennifer Walz, MLS - Head of Insanity 
Kinlaw Library -  Asbury University 
One Macklem Drive, Wilmore, KY 40390 
859-858-3511 ext. 2269



Reply via email to