Actions
Bug #3000
closedMultiple Permissions Orders exist for Single Document
Start date:
11/08/2007
Due date:
% Done:
0%
Estimated time:
Bugzilla-Id:
3000
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
Actions