Bug #3000
closedMultiple Permissions Orders exist for Single Document
0%
Description
Everytime "setaccess" is called for a document on MetacatServlet, a new row is
created in the xml_access table. Each row has a perm_order field; thus, multiple
orders will exist for that document. This will be problematic in determining which order to apply, and in creating an accurate eml-access control list xml doc.
The problem stems from xml_access not being normalized. perm_order is 1-to-many
to perm_type. Solutions are (in order of preferance):
1) Normalize the table (create a parent table)
or 2) Update perm_order in all existing rows everytime there is an access mod.
or 3) Add a timestamp field and apply the order in the last entry.
Related issues
Updated by ben leinfelder over 11 years ago
- Status changed from New to Closed
Mike added checks to prevent different permOrders from being inserted for the same object.