/src/edu/ucsb/nceas/metacat/PermissionController.java - Annotate - Metacat - Ecoinformatics Redmine

metacat/src/edu/ucsb/nceas/metacat/PermissionController.java @ 5644

-            tao
+/**
  *  '$RCSfile$'
  *    Purpose: A class that handles checking permssision for a document
-            sgarg
+               and subtree in a document
+ *
-            tao
+ *  Copyright: 2000 Regents of the University of California and the
  *             National Center for Ecological Analysis and Synthesis
  *    Authors: Chad Berkley
+ *
  *   '$Author$'
  *     '$Date$'
  * '$Revision$'
+ *
  * This program is free software; you can redistribute it and/or modify
  * it under the terms of the GNU General Public License as published by
  * the Free Software Foundation; either version 2 of the License, or
  * (at your option) any later version.
+ *
  * This program is distributed in the hope that it will be useful,
  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  * GNU General Public License for more details.
+ *
  * You should have received a copy of the GNU General Public License
  * along with this program; if not, write to the Free Software
  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
  */
 package edu.ucsb.nceas.metacat;
             sgarg
-            tao
+import java.sql.*;
-            tao
+import java.util.Enumeration;
-            tao
+import java.util.Hashtable;
-            daigle
+import java.util.Stack;
-            tao
+import java.util.Vector;
-            daigle
+import java.util.Iterator;
             tao
-            sgarg
+import org.apache.log4j.Logger;
-            daigle
+import edu.ucsb.nceas.metacat.accesscontrol.AccessControlForSingleFile;
 import edu.ucsb.nceas.metacat.accesscontrol.AccessControlInterface;
 import edu.ucsb.nceas.metacat.accesscontrol.AccessControlList;
-            daigle
+import edu.ucsb.nceas.metacat.database.DBConnection;
 import edu.ucsb.nceas.metacat.database.DBConnectionPool;
-            daigle
+import edu.ucsb.nceas.metacat.properties.PropertyService;
-            daigle
+import edu.ucsb.nceas.metacat.service.SessionService;
-            daigle
+import edu.ucsb.nceas.metacat.util.DocumentUtil;
-            daigle
+import edu.ucsb.nceas.metacat.util.MetacatUtil;
-            daigle
+import edu.ucsb.nceas.metacat.util.SessionData;
-            daigle
+import edu.ucsb.nceas.utilities.PropertyNotFoundException;
-            berkley
+import edu.ucsb.nceas.metacat.shared.ServiceException;
             daigle
-            tao
+public class PermissionController
+{
    private String docId = null;
    private boolean hasSubTreeAccessControl = false; // flag if has a subtree
                                                     // access for this docid
-            daigle
+   private Vector subTreeList = new Vector();
             sgarg
-            daigle
+   private static final long TOPLEVELSTARTNODEID = 0; //if start node is 0, means it is top
-            tao
+                                         //level document
             sgarg
-            sgarg
+   private static Logger logMetacat = Logger.getLogger(PermissionController.class);
             sgarg
-            tao
+   /**
     * Constructor for PermissionController
     * @param myDocid      the docid need to access
     */
-            tao
+   public PermissionController(String myDocid) throws McdbException
             tao
      // Get rid of rev number
-            daigle
+     docId = DocumentUtil.getSmartDocId(myDocid);
-            sgarg
+     //hasSubTreeAccessControl = checkSubTreeAccessControl();
             tao
             sgarg
-            tao
+   /**
-            sgarg
+    * Constructor for PermssionController
     * @param myDocid String
     * @param needDeleteRev boolean
     */
    public PermissionController(String myDocid, boolean needDeleteRevFromDocid)
+   {
      if (!needDeleteRevFromDocid)
+     {
        docId = myDocid;
+     }
      else
+     {
-            daigle
+         docId = DocumentUtil.getDocIdFromAccessionNumber(myDocid);
             sgarg
+   }
    /**
-            tao
+    * Return if a document has subtree access control
     */
    public boolean hasSubTreeAccessControl()
+   {
      return hasSubTreeAccessControl;
+   }
             sgarg
-            daigle
+   public boolean hasPermission(String sessionId, String myPermission) throws SQLException {
-            berkley
+       SessionData sessionData = null;
        sessionData = SessionService.getInstance().getRegisteredSession(sessionId);
        if (sessionData == null) {
            return false;
+       }
             daigle
 	   return hasPermission(sessionData.getUserName(), sessionData.getGroupNames(), myPermission);
+   }
             sgarg
-            tao
+  /**
     * Check from db connection if at least one of the list of @principals
     * @param user  the user name
     * @param groups  the groups which the use is in
     * @param myPermission  permission type to check for
     */
-            sgarg
+  public boolean hasPermission(String user, String[]groups, String myPermission)
-            daigle
+                              throws SQLException //, Exception
             tao
     boolean hasPermission=false;
     String [] userPackage=null;
     int permission =AccessControlList.intValue(myPermission);
             sgarg
-            tao
+    //for the commnad line invocation
     if ((user==null) && (groups==null || groups.length==0))
+    {
       return true;
+    }
             sgarg
-            tao
+    //create a userpackage including user, public and group member
     userPackage=createUsersPackage(user, groups);
             sgarg
-            tao
+    //if the requested document is access documents and requested permission
     //is "write", the user should have "all" right
             sgarg
-            tao
+    if (isAccessDocument(docId) && (permission == AccessControlInterface.WRITE))
+    {
             sgarg
-            tao
+      hasPermission = hasPermission(userPackage,docId, 7);// 7 is all permission
     }//if
     else //in other situation, just check the request permission
+    {
             sgarg
-            tao
+      // Check for @permission on @docid for @user and/or @groups
       hasPermission = hasPermission(userPackage,docId, permission);
             sgarg
-            tao
+    }//else
             sgarg
-            tao
+    return hasPermission;
+  }
             sgarg
-            tao
+  /**
     * Check from db connection if the users in String array @principals has
-            sgarg
+    * @permission on @docid*
-            tao
+    * @param principals, names in userPakcage need to check for @permission
     * @param docid, document identifier to check on
-            sgarg
+    * @param permission, permission (write or all...) to check for
-            tao
+    */
   private boolean hasPermission(String [] principals, String docId,
                                            int permission)
                          throws SQLException
+  {
-            tao
+    long startId = TOPLEVELSTARTNODEID;// this is for top level, so startid is 0
-            sgarg
+    try
             tao
       //first, if there is a docid owner in user package, return true
-            sgarg
+      //because doc owner has all permssion
-            tao
+      if (containDocumentOwner(principals, docId))
+      {
             sgarg
-            tao
+          return true;
+      }
             sgarg
-            tao
+      //If there is no owner in user package, checking the table
       //check perm_order
-            tao
+      if (isAllowFirst(principals, docId, startId))
             tao
             sgarg
-            tao
+        if (hasExplicitDenyRule(principals, docId, permission, startId))
             tao
           //if it is allowfirst and has deny rule(either explicit )
           //deny access
             sgarg
-            tao
+          return false;
         }//if
-            tao
+        else if ( hasAllowRule(principals, docId, permission, startId))
             tao
           //if it is allowfirst and hasn't deny rule and has allow rule
           //allow access
             sgarg
-            tao
+          return true;
         }//else if
         else
+        {
           //other situation deny access
             sgarg
-            tao
+          return false;
         }//else
      }//if isAllowFirst
      else //denyFirst
+     {
-            tao
+       if (hasAllowRule(principals, docId, permission, startId))
             tao
          //if it is denyFirst and has allow rule, allow access
          return true;
+       }
        else
+       {
          //if it is denyfirst but no allow rule, deny access
          return false;
+       }
      }//else denyfirst
     }//try
     catch (Exception e)
+    {
-            daigle
+      logMetacat.warn("PermissionController.hasPermission - There is a exception in hasPermission method: "
-            sgarg
+                         +e.getMessage());
             tao
             sgarg
-            tao
+    return false;
   }//hasPermission
             sgarg
-            tao
+  /**
-            sgarg
+   *  Method to check if a person has permission to a inline data file
    * @param user String
    * @param groups String[]
    * @param myPermission String
    * @param inlineDataId String
    * @throws McdbException
    * @return boolean
    */
   private boolean hasPermissionForInlineData(String user, String[] groups,
                                       String myPermission, String inlineDataId)
-            jones
+      throws McdbException
             sgarg
      // this method can call the public method - hasPermission(...)
      // the only difference is about the ownership, you couldn't find the owner
      // from inlinedataId directly. You should get it from eml document itself
      String []userPackage = createUsersPackage(user, groups);
-            jones
+     try {
         if (containDocumentOwner(userPackage, docId))
+         {
            return true;
+         }
          else
+         {
              PermissionController controller =
                                    new PermissionController(inlineDataId, false);
              return controller.hasPermission(user, groups, myPermission);
+         }
     } catch (SQLException e) {
         throw new McdbException(e.getMessage());
+    }
             sgarg
   /**
-            tao
+   * The method to determine of a node can be access by a user just by subtree
    * access control
    */
   public boolean hasPermissionForSubTreeNode(String user, String[] groups,
                                              String myPermission, long nodeId)
                                              throws McdbException
+  {
-            tao
+    boolean flag = true;
-            tao
+    // Get unaccessble subtree for this user
-            daigle
+    Hashtable unaccessableSubTree = hasUnaccessableSubTree(user, groups,
-            tao
+                                                           myPermission);
-            daigle
+    Enumeration en = unaccessableSubTree.elements();
-            tao
+    while (en.hasMoreElements())
+    {
       SubTree tree = (SubTree)en.nextElement();
       long start = tree.getStartNodeId();
       long stop  = tree.getEndNodeId();
-            tao
+      // nodeid in unaccessablesubtree, return false
-            tao
+      if ( nodeId >= start && nodeId <= stop)
+      {
-            tao
+        flag = false;
-            tao
+        break;
+      }
+    }
     return flag;
+  }
   /**
-            sgarg
+   * This method will return a hasTable of subtree which user doesn't has the
-            tao
+   * permssion to access
    * @param user  the user name
    * @param groups  the groups which the use is in
    * @param myPermission  permission type to check for
    */
-            daigle
+  public Hashtable hasUnaccessableSubTree(String user, String[] groups,
-            tao
+                                       String myPermission) throws McdbException
+  {
-            daigle
+    Hashtable resultUnaccessableSubTree = new Hashtable();
-            tao
+    String [] principals=null;
     int permission =AccessControlList.intValue(myPermission);
             sgarg
-            tao
+    //for the commnad line invocation return null(no unaccessable subtree)
     if ((user==null) && (groups==null || groups.length==0))
+    {
       return resultUnaccessableSubTree;
+    }
             sgarg
-            tao
+    //create a userpackage including user, public and group member
     principals=createUsersPackage(user, groups);
     //for the document owner return null(no unaccessable subtree)
     try
+    {
       if (containDocumentOwner(principals, docId))
+      {
        return resultUnaccessableSubTree;
+      }
+    }
     catch (SQLException ee)
+    {
       throw new McdbException(ee);
+    }
             sgarg
-            tao
+    // go through every subtree which has access control
     for (int i = 0; i< subTreeList.size(); i++)
+    {
       SubTree tree = (SubTree)subTreeList.elementAt(i);
-            tao
+      long startId = tree.getStartNodeId();
             sgarg
-            tao
+        try
+        {
-            tao
+          if (isAllowFirst(principals, docId, startId))
             tao
             sgarg
-            tao
+            if (hasExplicitDenyRule(principals, docId, permission, startId ))
             tao
             sgarg
-            tao
+             //if it is allowfirst and has deny rule
               // put the subtree into unaccessable vector
-            tao
+              if (!resultUnaccessableSubTree.containsKey(new Long(startId)))
             tao
-            tao
+                resultUnaccessableSubTree.put(new Long(startId), tree);
             tao
             }//if
-            tao
+            else if ( hasAllowRule(principals, docId, permission, startId))
             tao
               //if it is allowfirst and hasn't deny rule and has allow rule
               //allow access do nothing
             sgarg
-            tao
+            }//else if
             else
+            {
               //other situation deny access
-            tao
+              if (!resultUnaccessableSubTree.containsKey(new Long(startId)))
             tao
-            tao
+                resultUnaccessableSubTree.put(new Long(startId), tree);
             tao
             sgarg
-            tao
+            }//else
           }//if isAllowFirst
           else //denyFirst
+          {
-            tao
+            if (hasAllowRule(principals, docId, permission,startId))
             tao
               //if it is denyFirst and has allow rule, allow access, do nothing
             sgarg
             tao
             else
+            {
               //if it is denyfirst but no allow rule, deny access
               // add into vector
-            tao
+              if (!resultUnaccessableSubTree.containsKey(new Long(startId)))
             tao
-            tao
+                resultUnaccessableSubTree.put(new Long(startId), tree);
             tao
+            }
           }//else denyfirst
         }//try
         catch( Exception e)
+        {
-            daigle
+          logMetacat.error("PermissionController.hasUnaccessableSubTree - error in PermissionControl.has" +
-            sgarg
+                                   "UnaccessableSubTree "+e.getMessage());
-            tao
+          throw new McdbException(e);
+        }
             sgarg
-            tao
+    }//for
-            sgarg
+    // merge the subtree if a subtree is another subtree'subtree
-            tao
+    resultUnaccessableSubTree = mergeEquivalentSubtree(resultUnaccessableSubTree);
-            tao
+    return resultUnaccessableSubTree;
   }//hasUnaccessableSubtree
             sgarg
   /*
-            tao
+   * A method to merge nested subtree into bigger one. For example subtree b
    * is a subtree of subtree a. And user doesn't have read permission for both
    * so we only use subtree a is enough.
    */
-            daigle
+  private Hashtable mergeEquivalentSubtree(Hashtable unAccessSubTree)
             tao
-            daigle
+    Hashtable newSubTreeHash = new Hashtable();
-            tao
+    boolean   needDelete = false;
     // check the parameters
     if (unAccessSubTree == null || unAccessSubTree.isEmpty())
+    {
       return newSubTreeHash;
+    }
     else
+    {
       // look every subtree start point and stop point, to see if it is embedded
       // in another one. If embedded, they are equavelent and we can use bigger
       // one to replace smaller one
-            daigle
+      Enumeration en = unAccessSubTree.elements();
-            tao
+      while (en.hasMoreElements())
+      {
         SubTree tree    = (SubTree)en.nextElement();
         String  treeId  = tree.getSubTreeId();
         long    startId = tree.getStartNodeId();
         long    endId   = tree.getEndNodeId();
             sgarg
-            daigle
+        Enumeration enu = unAccessSubTree.elements();
-            tao
+        while (enu.hasMoreElements())
+        {
           SubTree subTree = (SubTree)enu.nextElement();
-            daigle
+          String subTreeId= subTree.getSubTreeId();
-            tao
+          long   subTreeStartId = subTree.getStartNodeId();
           long   subTreeEndId   = subTree.getEndNodeId();
           //compare and if the first subtree is a subtree of the second
           // one, set neeDelete true
           if (startId > subTreeStartId && endId < subTreeEndId)
+          {
             needDelete = true;
-            daigle
+            logMetacat.info("PermissionController.mergeEquivalentSubtree - the subtree: "+ treeId +
-            tao
+                                     " need to be get rid of from unaccessable"+
                                      " subtree list becuase it is a subtree of"+
-            sgarg
+                                     " another subtree in the list");
-            tao
+            break;
           }//if
         }//while
         // if not need to delete, put the subtree into hash
         if (!needDelete)
+        {
-            tao
+          newSubTreeHash.put(new Long(startId), tree);
             tao
         //reset needDelete
         needDelete = false;
       }//while
       return newSubTreeHash;
     }//else
+  }
             sgarg
-            tao
+  /**
-            daigle
+	 * Check if a document id is a access document. Access document need user
 	 * has "all" permission to access it.
+	 *
 	 * @param docId,
 	 *            the document id need to be checked
 	 */
 	private boolean isAccessDocument(String docId) throws SQLException {
 		// detele the rev number if docid contains it
-            daigle
+		docId = DocumentUtil.getDocIdFromString(docId);
-            daigle
+		PreparedStatement pStmt = null;
 		DBConnection conn = null;
 		int serialNumber = -1;
 		try {
 			// check out DBConnection
 			conn = DBConnectionPool.getDBConnection("PermissionControl.isAccessDoc");
 			serialNumber = conn.getCheckOutSerialNumber();
 			pStmt = conn.prepareStatement("select doctype from xml_documents where "
 					+ "docid like '" + docId + "'");
 			pStmt.execute();
 			ResultSet rs = pStmt.getResultSet();
 			boolean hasRow = rs.next();
 			String doctype = null;
 			if (hasRow) {
 				doctype = rs.getString(1);
             sgarg
             daigle
 			pStmt.close();
             sgarg
-            daigle
+			// if it is an access document
 			if (doctype != null
-            daigle
+					&& ((MetacatUtil.getOptionList(PropertyService
-            daigle
+							.getProperty("xml.accessdoctype")).contains(doctype)))) {
             sgarg
-            daigle
+				return true;
+			}
             sgarg
-            daigle
+		} catch (SQLException e) {
 			throw new SQLException("PermissionControl.isAccessDocument "
 					+ "Error checking" + " on document " + docId + ". " + e.getMessage());
 		} catch (PropertyNotFoundException pnfe) {
 			throw new SQLException("PermissionControl.isAccessDocument "
 					+ "Error checking" + " on document " + docId + ". " + pnfe.getMessage());
 		} finally {
 			try {
 				pStmt.close();
 			} finally {
 				DBConnectionPool.returnDBConnection(conn, serialNumber);
+			}
+		}
             sgarg
-            daigle
+		return false;
 	}// isAccessDocument
             sgarg
-            tao
+  /**
-            daigle
+	 * Check if a stirng array contains a given documents' owner
+	 *
 	 * @param principals,
 	 *            a string array storing the username, groups name and public.
 	 * @param docid,
 	 *            the id of given documents
 	 */
-            tao
+  private boolean containDocumentOwner( String[] principals, String docId)
-            tao
+                    throws SQLException
+  {
     int lengthOfArray=principals.length;
-            sgarg
+    boolean hasRow;
-            tao
+    PreparedStatement pStmt=null;
     DBConnection conn = null;
     int serialNumber = -1;
             sgarg
-            tao
+    try
+    {
       //check out DBConnection
-            tao
+     conn=DBConnectionPool.getDBConnection("PermissionControl.containDocOnwer");
-            tao
+      serialNumber=conn.getCheckOutSerialNumber();
       pStmt = conn.prepareStatement(
                 "SELECT 'x' FROM xml_documents " +
-            sgarg
+                "WHERE docid = ? AND lower(user_owner) = ?");
-            tao
+      //check every element in the string array too see if it conatains
       //the owner of document
       for (int i=0; i<lengthOfArray; i++)
+      {
             sgarg
-            tao
+        // Bind the values to the query
         pStmt.setString(1, docId);
         pStmt.setString(2, principals[i]);
-            daigle
+        logMetacat.info("PermissionController.containDocumentOwner - the principle stack is : " +
-            sgarg
+                                  principals[i]);
             tao
         pStmt.execute();
         ResultSet rs = pStmt.getResultSet();
         hasRow = rs.next();
-            sgarg
+        if (hasRow)
             tao
           pStmt.close();
-            daigle
+           logMetacat.info("PermissionController.containDocumentOwner - find the owner");
-            tao
+          return true;
-            sgarg
+        }//if
-            tao
+      }//for
     }//try
-            sgarg
+    catch (SQLException e)
             tao
         pStmt.close();
             sgarg
         throw new
-            daigle
+        SQLException("PermissionControl.hasPermission - " +
-            tao
+                     "Error checking ownership for " + principals[0] +
                      " on document #" + docId + ". " + e.getMessage());
     }//catch
     finally
+    {
       try
+      {
         pStmt.close();
+      }
       finally
+      {
         DBConnectionPool.returnDBConnection(conn, serialNumber);
+      }
+    }
-            sgarg
+    return false;
-            tao
+  }//containDocumentOwner
             sgarg
-            tao
+  /**
     * Check if the permission order for user at that documents is allowFirst
-            sgarg
+    * @param principals, list of names of principals to check for
-            tao
+    * @param docid, document identifier to check for
     */
-            sgarg
+  private boolean isAllowFirst(String [] principals, String docId,
-            tao
+                               long startId)
-            tao
+                  throws SQLException, Exception
+  {
     int lengthOfArray=principals.length;
     boolean hasRow;
     PreparedStatement pStmt = null;
     DBConnection conn = null;
     int serialNumber = -1;
-            tao
+    String sql = null;
     boolean topLever =false;
-            tao
+    if (startId == TOPLEVELSTARTNODEID)
             tao
       //top level
       topLever = true;
       sql = "SELECT perm_order FROM xml_access " +
-            tao
+    "WHERE lower(principal_name) = ? AND docid = ? AND startnodeid is NULL";
             tao
     else
+    {
       //sub tree level
       sql = "SELECT perm_order FROM xml_access " +
-            tao
+        "WHERE lower(principal_name)= ? AND docid = ? AND startnodeid = ?";
             tao
             sgarg
-            tao
+    try
+    {
       //check out DBConnection
       conn=DBConnectionPool.getDBConnection("AccessControlList.isAllowFirst");
       serialNumber=conn.getCheckOutSerialNumber();
             sgarg
-            tao
+      //select permission order from database
-            tao
+      pStmt = conn.prepareStatement(sql);
             sgarg
-            tao
+      //check every name in the array
       for (int i=0; i<lengthOfArray;i++)
+      {
         //bind value
         pStmt.setString(1, principals[i]);//user name
         pStmt.setString(2, docId);//docid
             sgarg
         // if subtree, we need set subtree id
-            tao
+        if (!topLever)
+        {
-            tao
+          pStmt.setLong(3, startId);
             tao
             sgarg
-            tao
+        pStmt.execute();
         ResultSet rs = pStmt.getResultSet();
         hasRow=rs.next();
         if (hasRow)
+        {
           //get the permission order from data base
           String permissionOrder=rs.getString(1);
           //if the permission order is "allowFirst
           if (permissionOrder.equalsIgnoreCase(AccessControlInterface.ALLOWFIRST))
+          {
             pStmt.close();
             return true;
+          }
           else
+          {
             pStmt.close();
             return false;
+          }
         }//if
       }//for
     }//try
     catch (SQLException e)
+    {
       throw e;
+    }
     finally
+    {
       try
+      {
         pStmt.close();
+      }
       finally
+      {
         DBConnectionPool.returnDBConnection(conn, serialNumber);
+      }
+    }
             sgarg
     //if reach here, means there is no permssion record for given names and
-            tao
+    //docid. So throw a exception.
             sgarg
-            daigle
+    throw new Exception("PermissionController.isAllowFirst - There is no permission record for user "+ principals[0] +
                         " at document " + docId);
             sgarg
-            tao
+  }//isAllowFirst
             sgarg
-            tao
+  /**
-            sgarg
+    * Check if the users array has allow rules for given users, docid and
-            tao
+    * permission.
     * If it has permission rule and ticket count is greater than 0, the ticket
     * number will decrease one for every allow rule
-            sgarg
+    * @param principals, list of names of principals to check for
-            tao
+    * @param docid, document identifier to check for
     * @param permission, the permssion need to check
     */
-            sgarg
+  private boolean hasAllowRule(String [] principals, String docId,
-            tao
+                                  int permission, long startId)
-            tao
+                  throws SQLException, Exception
+ {
    int lengthOfArray=principals.length;
    boolean allow=false;//initial value is no allow rule
    ResultSet rs;
    PreparedStatement pStmt = null;
    int permissionValue=permission;
    int permissionValueInTable;
-            daigle
+   int ticketCount;
-            tao
+   DBConnection conn = null;
    int serialNumber = -1;
-            tao
+   boolean topLever = false;
    String sql = null;
-            tao
+   if (startId == TOPLEVELSTARTNODEID)
             tao
      // for toplevel
      topLever = true;
-            sgarg
+     sql = "SELECT permission FROM xml_access WHERE docid = ? " +
-            tao
+   "AND lower(principal_name) = ? AND perm_type = ? AND startnodeid is NULL";
             tao
    else
+   {
      topLever =false;
-            sgarg
+     sql = "SELECT permission FROM xml_access WHERE docid = ? " +
-            tao
+      "AND lower(principal_name) = ? AND perm_type = ? AND startnodeid = ?";
             tao
-            tao
+   try
+   {
      //check out DBConnection
      conn=DBConnectionPool.getDBConnection("AccessControlList.hasAllowRule");
      serialNumber=conn.getCheckOutSerialNumber();
-            sgarg
+    //This sql statement will select entry with
-            tao
+    //begin_time<=currentTime<=end_time in xml_access table
     //If begin_time or end_time is null in table, isnull(begin_time, sysdate)
     //function will assign begin_time=sysdate
-            tao
+    pStmt = conn.prepareStatement(sql);
-            tao
+    //bind docid, perm_type
     pStmt.setString(1, docId);
     pStmt.setString(3, AccessControlInterface.ALLOW);
             sgarg
-            tao
+    // if subtree lever, need to set subTreeId
     if (!topLever)
+    {
-            tao
+      pStmt.setLong(4, startId);
             tao
             sgarg
-            tao
+    //bind every elenment in user name array
     for (int i=0;i<lengthOfArray; i++)
+    {
       pStmt.setString(2, principals[i]);
       pStmt.execute();
       rs=pStmt.getResultSet();
       while (rs.next())//check every entry for one user
+      {
         permissionValueInTable=rs.getInt(1);
             sgarg
         //permission is ok
-            tao
+        //the user have a permission to access the file
         if (( permissionValueInTable & permissionValue )== permissionValue )
+        {
             sgarg
-            tao
+           allow=true;//has allow rule entry
         }//if
       }//while
     }//for
    }//try
    catch (SQLException sqlE)
+   {
      throw sqlE;
+   }
    catch (Exception e)
+   {
      throw e;
+   }
    finally
+   {
      try
+     {
        pStmt.close();
+     }
      finally
+     {
        DBConnectionPool.returnDBConnection(conn, serialNumber);
+     }
+   }
     return allow;
  }//hasAllowRule
             sgarg
-            tao
+   /**
-            sgarg
+    * Check if the users array has explicit deny rules for given users, docid
-            tao
+    * and permission. That means the perm_type is deny and current time is
     * less than end_time and greater than begin time, or no time limit.
-            sgarg
+    * @param principals, list of names of principals to check for
-            tao
+    * @param docid, document identifier to check for
     * @param permission, the permssion need to check
     */
-            sgarg
+  private boolean hasExplicitDenyRule(String [] principals, String docId,
-            tao
+                                      int permission, long startId)
-            tao
+                  throws SQLException
+ {
    int lengthOfArray=principals.length;
    ResultSet rs;
    PreparedStatement pStmt = null;
    int permissionValue=permission;
    int permissionValueInTable;
    DBConnection conn = null;
    int serialNumber = -1;
-            tao
+   String sql = null;
    boolean topLevel = false;
             sgarg
-            tao
+   // decide top level or subtree level
-            tao
+   if (startId == TOPLEVELSTARTNODEID)
             tao
      topLevel = true;
-            sgarg
+     sql = "SELECT permission FROM xml_access WHERE docid = ? " +
-            tao
+    "AND lower(principal_name) = ? AND perm_type = ? AND startnodeid is NULL";
             tao
    else
+   {
      topLevel = false;
-            sgarg
+     sql = "SELECT permission FROM xml_access WHERE docid = ? " +
-            tao
+     "AND lower(principal_name) = ? AND perm_type = ? AND startnodeid = ?";
             tao
             sgarg
-            tao
+   try
+   {
      //check out DBConnection
-            tao
+     conn=DBConnectionPool.getDBConnection("PermissionControl.hasExplicitDeny");
-            tao
+     serialNumber=conn.getCheckOutSerialNumber();
             sgarg
-            tao
+     pStmt = conn.prepareStatement(sql);
-            tao
+    //bind docid, perm_type
     pStmt.setString(1, docId);
     pStmt.setString(3, AccessControlInterface.DENY);
             sgarg
-            tao
+    // subtree level need to set up subtreeid
     if (!topLevel)
+    {
-            tao
+      pStmt.setLong(4, startId);
             tao
             sgarg
-            tao
+    //bind every elenment in user name array
     for (int i=0;i<lengthOfArray; i++)
+    {
       pStmt.setString(2, principals[i]);
       pStmt.execute();
       rs=pStmt.getResultSet();
       while (rs.next())//check every entry for one user
+      {
         permissionValueInTable=rs.getInt(1);
             sgarg
-            tao
+        //permission is ok the user doesn't have permission to access the file
         if (( permissionValueInTable & permissionValue )== permissionValue )
             sgarg
             tao
            pStmt.close();
            return true;
          }//if
       }//while
     }//for
    }//try
    catch (SQLException e)
+   {
      throw e;
    }//catch
    finally
+   {
      try
+     {
        pStmt.close();
+     }
      finally
+     {
        DBConnectionPool.returnDBConnection(conn, serialNumber);
+     }
    }//finally
    return false;//no deny rule
-            sgarg
+  }//hasExplicitDenyRule
             tao
             sgarg
-            tao
+  /**
     * Creat a users pakages to check permssion rule, user itself, public and
     * the gourps the user belong will be include in this package
     * @param user, the name of user
     * @param groups, the string array of the groups that user belong to
     */
   private String[] createUsersPackage(String user, String [] groups)
+  {
     String [] usersPackage=null;
     int lengthOfPackage;
             sgarg
-            tao
+    if (groups!=null)
+    {
-            sgarg
+      //if gouprs is not null and user is not public, we should create a array
       //to store the groups and user and public.
-            tao
+      //So the length of userPackage is the length of group plus two
       if (!user.equalsIgnoreCase(AccessControlInterface.PUBLIC))
+      {
         lengthOfPackage=(groups.length)+2;
         usersPackage=new String [lengthOfPackage];
         //the first two elements is user self and public
-            tao
+        //in order to ignore case sensitive, we transfer user to lower case
         if (user != null)
+        {
           usersPackage[0]= user.toLowerCase();
-            daigle
+          logMetacat.info("PermissionController.createUsersPackage - after transfer to lower case(not null): "+
-            sgarg
+                                     usersPackage[0]);
             tao
         else
+        {
           usersPackage[0] = user;
           usersPackage[0]= user.toLowerCase();
-            daigle
+          logMetacat.info("PermissionController.createUsersPackage - after transfer to lower case(null): "+
-            sgarg
+                                     usersPackage[0]);
             tao
-            tao
+        usersPackage[1]=AccessControlInterface.PUBLIC;
         //put groups element from index 0 to lengthOfPackage-3 into userPackage
         //from index 2 to lengthOfPackage-1
         for (int i=2; i<lengthOfPackage; i++)
+        {
-            tao
+          //tansfer group to lower case too
           if (groups[i-2] != null)
+          {
             usersPackage[i]=groups[i-2].toLowerCase();
+          }
-            tao
+        } //for
       }//if user!=public
       else//use=public
+      {
         lengthOfPackage=(groups.length)+1;
         usersPackage=new String [lengthOfPackage];
         //the first lements is public
         usersPackage[0]=AccessControlInterface.PUBLIC;
         //put groups element from index 0 to lengthOfPackage-2 into userPackage
         //from index 1 to lengthOfPackage-1
         for (int i=1; i<lengthOfPackage; i++)
+        {
-            tao
+          if (groups[i-1] != null)
+          {
             usersPackage[i]=groups[i-1].toLowerCase();
+          }
-            tao
+        } //for
       }//else user=public
             sgarg
-            tao
+    }//if groups!=null
     else
+    {
       //because no groups, the userPackage only need two elements
       //one is for user, the other is for public
       if (!user.equalsIgnoreCase(AccessControlInterface.PUBLIC))
+      {
         lengthOfPackage=2;
         usersPackage=new String [lengthOfPackage];
-            tao
+        if (user != null)
+        {
           usersPackage[0]=user.toLowerCase();
+        }
         else
+        {
           usersPackage[0]=user;
+        }
-            tao
+        usersPackage[1]=AccessControlInterface.PUBLIC;
       }//if user!=public
       else //user==public
+      {
         //only put public into array
         lengthOfPackage=1;
         usersPackage=new String [lengthOfPackage];
         usersPackage[0]=AccessControlInterface.PUBLIC;
+      }
     }//else groups==null
     return usersPackage;
   }//createUsersPackage
             sgarg
-            tao
+  /**
-            sgarg
+   * A static method to get Hashtable which cointains a inlinedata object list that
    * user can't read it. The key is subtree id of inlinedata, the data is
    * internal file name for the inline data which is stored as docid
    * in xml_access table or data object doc id.
    * @param docidWithoutRev, metadata docid which should be the accessfileid
    *                         in the table
    * @param user , the name of user
    * @param groups, the group which the user belong to
-            tao
+   */
-            daigle
+   public static Hashtable<String, String> getUnReadableInlineDataIdList(String docidWithoutRev,
-            sgarg
+                                                   String user, String[] groups,
                                                    boolean withRevision)
-            jones
+                                                throws McdbException
             sgarg
-            daigle
+     Hashtable<String, String> inlineDataList = getUnAccessableInlineDataIdList(docidWithoutRev,
-            sgarg
+                              user, groups, AccessControlInterface.READSTRING,
                               withRevision);
             sgarg
      return inlineDataList;
+   }
    /**
   * A static method to get Hashtable which cointains a inline  data object list that
   * user can't overwrite it. The key is subtree id of inline data distrubition,
   * the value is internal file name for the inline data which is stored as docid
   * in xml_access table or data object doc id.
   * @param docidWithoutRev, metadata docid which should be the accessfileid
   *                         in the table
   * @param user , the name of user
   * @param groups, the group which the user belong to
   */
-            daigle
+  public static Hashtable<String, String> getUnWritableInlineDataIdList(String docidWithoutRev,
-            sgarg
+                                                  String user, String[] groups,
                                                   boolean withRevision)
-            sgarg
+                                               throws Exception
             tao
-            daigle
+    Hashtable<String, String> inlineDataList = getUnAccessableInlineDataIdList(docidWithoutRev,
-            sgarg
+                            user, groups, AccessControlInterface.WRITESTRING,
                             withRevision);
             sgarg
     return inlineDataList;
+  }
    /*
     * This method will get hashtable which contains a unaccessable distribution
     * inlinedata object list
             sgarg
     * withRevision is used to get inline id list with or without revision number
     * e.g. when withRevision is true, temp.1.1.1, temp.1.1.2 would be returned
     * otherwise temp.1.1 and temp.1.2 would be returned.
-            sgarg
+    */
-            daigle
+   private static Hashtable<String, String> getUnAccessableInlineDataIdList(String docid,
-            sgarg
+                               String user, String[] groups, String permission,
                                boolean withRevision)
-            jones
+                             throws McdbException
             sgarg
-            jones
+       Hashtable<String, String> unAccessibleIdList = new Hashtable();
        if (user == null) {
            return unAccessibleIdList;
+       }
        Hashtable allIdList;
        try {
            allIdList = getAllInlineDataIdList(docid);
        } catch (SQLException e) {
            throw new McdbException(e.getMessage());
+       }
        Enumeration<String> en = allIdList.keys();
-            sgarg
+      while (en.hasMoreElements())
             tao
-            sgarg
+        String subTreeId = (String) en.nextElement();
         String fileId = (String) allIdList.get(subTreeId);
         //Here fileid is internal file id for line data. It stored in docid
         // field in xml_access table. so we don't need to delete rev
         PermissionController controller = new PermissionController(docid, false);
         if (!controller.hasPermissionForInlineData(user, groups, permission, fileId))
+        {
-            sgarg
+            if(withRevision)
+            {
-            daigle
+                logMetacat.info("PermissionController.getUnAccessableInlineDataIdList - Put subtree id " + subTreeId +
-            sgarg
+                                         " and " + "inline data file name " +
                                          fileId + " into " + "un" + permission +
-            sgarg
+                                         " hash");
-            daigle
+                unAccessibleIdList.put(subTreeId, fileId);
             sgarg
+            }
             else
+            {
-            daigle
+                logMetacat.info("PermissionController.getUnAccessableInlineDataIdList - Put subtree id " + subTreeId +
-            sgarg
+                                         " and " + "inline data file name " +
-            daigle
+                                         DocumentUtil.getInlineDataIdWithoutRev(fileId) +
-            sgarg
+                                         " into " + "un" + permission +
-            sgarg
+                                         " hash");
-            daigle
+                unAccessibleIdList.put(subTreeId,
                 		DocumentUtil.getInlineDataIdWithoutRev(fileId));
             sgarg
             sgarg
             tao
-            daigle
+      return unAccessibleIdList;
             sgarg
    /*
     * This method will get a hash table from xml_access table for all records
     * about the inline data. The key is subtree id and data is a inline internal
     * file name
     */
-            daigle
+   private static Hashtable getAllInlineDataIdList(String docid) throws SQLException
             sgarg
-            daigle
+     Hashtable inlineDataList = new Hashtable();
-            sgarg
+     String sql = "SELECT subtreeid, docid FROM xml_access WHERE " +
                    "accessfileid = ? AND subtreeid  IS NOT NULL";
      PreparedStatement pStmt=null;
      ResultSet rs=null;
      DBConnection conn=null;
      int serialNumber=-1;
      try
+     {
        //check out DBConnection
        conn=DBConnectionPool.getDBConnection("PermissionControl.getDataSetId");
        serialNumber=conn.getCheckOutSerialNumber();
        pStmt=conn.prepareStatement(sql);
        //bind the value to query
        pStmt.setString(1, docid);
        //execute the query
        pStmt.execute();
        rs=pStmt.getResultSet();
        //process the result
        while(rs.next())
+       {
          String subTreeId = rs.getString(1);
          String inlineDataId = rs.getString(2);
          if (subTreeId != null && !subTreeId.trim().equals("") &&
             inlineDataId != null && !inlineDataId.trim().equals(""))
+         {
            inlineDataList.put(subTreeId, inlineDataId);
+         }
       }//while
      }//try
      finally
+     {
        try
+       {
          pStmt.close();
+       }
        finally
+       {
          DBConnectionPool.returnDBConnection(conn, serialNumber);
+       }
      }//finally
      return inlineDataList;
    }//getAllInlineDataIdList
             tao

Project

General

Profile

Metacat