[OPEN-ILS-GENERAL] All permission groups deleted?

[Thomas Berezansky]

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 possible.

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 [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Walz, Jennifer
Sent: Tuesday, July 05, 2016 11:54
To: Evergreen Discussion Group <open-ils-general at list.georgialibraries.org>
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?  

 

Thanks!

 

Jennifer

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