Metacat

        String ownerQuery = getOwnerQuery(user);

        //MetaCatUtil.debugMessage("query: "+ownerQuery, 30);

        // if query is not the owner query, we need to check the permission

        // otherwise we don't need (owner has all permission by default)

        if (!query.equals(ownerQuery))

        {

          // set user name and group

          qspec.setUserName(user);

          qspec.setGroup(groups);

          // Get access query

          String accessQuery = qspec.getAccessQuery();

          query = query + accessQuery;

          MetaCatUtil.debugMessage(" final query: "+query, 30);

        }

  /*

   * A method to create a query to get owner's docid list

   */

  private String getOwnerQuery(String owner)

  {

    StringBuffer self = new StringBuffer();

    self.append("SELECT docid,docname,doctype,");

    self.append("date_created, date_updated, rev ");

    self.append("FROM xml_documents WHERE docid IN (");

    self.append("(");

    self.append("SELECT DISTINCT docid FROM xml_nodes WHERE \n");

    self.append("nodedata LIKE '%%%' ");

    self.append(") \n");

    self.append(") ");

    self.append(" AND (");

    self.append(" user_owner = '" + owner + "'");

    self.append(") ");

    return self.toString();

  }