Project

General

Profile

Actions

Bug #3000

closed

Multiple Permissions Orders exist for Single Document

Added by Chris Barteau about 17 years ago. Updated over 11 years ago.

Status:
Closed
Priority:
Normal
Category:
metacat
Target version:
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

Blocked by Metacat - Bug #2984: "AccessControlList.getACL" returns outdated XML structureClosedMichael Daigle10/15/2007

Actions
Actions #1

Updated by Redmine Admin over 11 years ago

Original Bugzilla ID was 3000

Actions #2

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.

Actions

Also available in: Atom PDF