In drupal you can create custom content types and set the system up to almost whatever you want. In this case I would recommend you to use the following modules:
User Roles can be managed with the built-in options plus per field permissions (available with the content module). You can assign as many roles to an user as you want
Using the User Import module you can import users in many ways, but it isn't that automated. You will have to export your user db as CSV and then import it into drupal. The modules then allows you to map the fields.
Install drupal 6 (mysql+php) [you may also go with drupal 7 but right now there are more tutorials and module sfor drupal 6, as d7 just went out, and the user import module is still not available for d7]
Enable the modules I recommended
Create a new content type (ex. File) and add a filetype field
Create a taxonomy vocabulary to create "categories" for the files and assign it to the "Files" content type
Create some roles (ex. editor, owner, read-only and so on) and assign different permissions depending of what you want each role to do
go to the User import module and import your user db (you can also update the existing users) and map the fields (the important ones are username, password, roles) to the fields in your csv file
create some views to show the content (files) like you want (for example, by category), by role, etc...
I think those are the basic steps to have a working download area like the one you want. Of course you may customize it as much as you like (that's the power of drupal) by adding more modules ( http://drupalmodules.com/ is a really good place to start )
Once you have the basics working you can start playing with panels http://drupal.org/project/ to customize the layout of the entire site and check some of the themes in http://drupal.org/project/Themes to change the look&feel of your site (you can also go with pure css)
I hope it helps. If you want to add another feature to this solution or something isn't clear enough please let me know.
Apache Lenya could work. You'd have to write your own authentication mechanism and group management code to sync over the users from the DB. Any product is going to give you difficulty going against a proprietary DB. If you were able to put the user and group data into a directory, say LDAP, your problem becomes a lot easier.
Joomla! with DOCman component: permissions can be granted only to 1 user or 1 group
This should actually work for you. You can create a single group for the file you want to manage and add/remove people to that group as they gain/lose access to the file.
I am not sure if this answers 100% of your issues however I have used Daisy-cms as a document management system.
With Daisy you can setup Attachment documents or your own document types. You cannot create folders however you can have access (this is the tricky part) based on Values in the fields.
It's open source, simple to install against MySQL and point and click for most of what you want to do.
这样您就可以使用属于主 Web 应用程序（或其他任何内容）的用户和组的帐户登录数据库中包含用户和组表的应用程序！）以及 Quotero DMS 的文件和文件夹的权限可以参考这些。其他数据，例如属于经典域的权限、文档、任务、工作流程、用户和组，将保留在 Quotero DB 中。 因此，您有 2 个数据库：一个用于整个 Quotero DMS，另一个（已经存在）用于 Quotero 检索用户和组（无需复制这些数据）。
编辑：
I不得不面对一些损害 Quotero 工作的错误...所以我不得不放弃这个解决方案。
I found these possible solutions:
LetoDMS (ex MyDMS), written in PHP, has it's own users and groups tables, old-fashioned style, less user-friendly
Quotero, written in Java, with LDAP, Active Directory, Joomla authentication support; more custom authentication sources can be built (starting from this tutorial); it's project seems more active; it has the most user-friendly and modern layout
Even if it has some bugs, I've choosen Quotero, for the above reasons. It's extensibility (relative to what I need) surprised me.
How I installed (in Tomcat 6 on Ubuntu Server 10 and Tomcat 7 on Windows 7) and integrated it with my main webapp:
install MySQL, PostgreSQL, Oracle DB, SQL Server or another DBMS (the last requires customization)
the wizard will create the DB and 2 .war in webapps folder: QuoteroServer and QuoteroClient; users will use the latter
in Linux systems it will probably place these webapps in /usr/share/tomcatx/webapps folder; if you need them in /var/lib/tomcatx/webapps, just move them
write your custom classes for the authentication source, following Joomla15's example and this tutorial
org.coretechs.quotero.user.impl.AuthenticationSourceFoo (the main class; it handles also the parameters asked in domain creation)
org.coretechs.quotero.user.impl.factory.foo.FooUserFactory (interacts with users table)
org.coretechs.quotero.user.impl.factory.foo.FooGroupFactory (interacts with groups table)
org.coretechs.quotero.user.impl.factory.foo.FooDBManagerDB2 (interacts with the DB)
insert such classes inside an Eclipse (or similar IDE) project, setting the build path with all libraries you can find in QuoteroServer/WEB-INF/lib and QuoteroClient/WEB-INF/lib
generate a .jar and place it in QuoteroServer/WEB-INF/lib
place the .jar with your DB driver in the same folder
open Toolbox > Administration > Domains and add a new domain, choosing as Domain Type your custom authentication source and setting the parameters, such as DB URL, username and password
In this way you can log in with the accounts belonging to users and groups of your main webapp (or whatever application with users and groups tables in a DB!) and also permissions on files and folders of Quotero DMS can be referred to those ones. Other data, such as permissions, documents, tasks, workflows, user and groups belonging to classical domain, will remain in the Quotero DB. So you have 2 DB: one for the whole Quotero DMS and one (already existing) where Quotero retreives users and groups (no need to replicate these data).
EDIT:
I had to face some bugs that compromise the working of Quotero... so I had to abandon this solution.
我最终决定使用商业客户端-服务器 DMS 并在其之上构建一个 Web 应用程序来检索文档及其关系。文档访问控制由 DMS 管理，并提供用户名和密码。用户和组可以轻松添加到 DMS。这是基础设施：
SOAP WCF connector (DLL)
webapp (JSP, mapping) ----> web service (C#) ------------------> WCF (DMS server)
I finally decided to use a commercial client-server DMS and built on top of it a webapp for retrieving documents and their relationships. Documents access control is managed by the DMS, given username and password. Users and groups can be easily added to the DMS. This is the infrastructure:
SOAP WCF connector (DLL)
webapp (JSP, mapping) ----> web service (C#) ------------------> WCF (DMS server)
发布评论
评论（6）
所以...为了使想法清晰，您需要：
我会是要点（如果我错过了任何要点，请添加它们作为评论以更新此答案）
在 drupal 中，您可以创建自定义内容类型并将系统设置为几乎任何您想要的内容。在这种情况下，我建议您使用以下模块：
用户角色可以使用内置选项以及每个字段权限进行管理（可通过内容模块）。您可以根据需要向用户分配任意数量的角色
使用用户导入模块，您可以通过多种方式导入用户，但它不是那么自动化。您必须将用户数据库导出为 CSV，然后将其导入到 drupal 中。然后，这些模块允许您映射字段。
步骤应该是：
我认为这些是拥有工作下载区域的基本步骤就像你想要的那样。当然，您可以通过添加更多模块（ http://drupalmodules.com / 是一个非常好的起点）
一旦您掌握了基础知识，您就可以开始使用面板 http:// /drupal.org/project/ 自定义整个站点的布局并检查 http 中的一些主题://drupal.org/project/Themes 来改变你网站的外观和感觉（你也可以使用纯CSS）
我希望它有帮助。如果您想为此解决方案添加其他功能或有些内容不够清晰，请告诉我。
干杯!
so... to make thinks clear, you need:
I those would be the main points (If I missed any, please add them as comments to update this answer)
In drupal you can create custom content types and set the system up to almost whatever you want. In this case I would recommend you to use the following modules:
User Roles can be managed with the built-in options plus per field permissions (available with the content module). You can assign as many roles to an user as you want
Using the User Import module you can import users in many ways, but it isn't that automated. You will have to export your user db as CSV and then import it into drupal. The modules then allows you to map the fields.
The steps should be:
I think those are the basic steps to have a working download area like the one you want. Of course you may customize it as much as you like (that's the power of drupal) by adding more modules ( http://drupalmodules.com/ is a really good place to start )
Once you have the basics working you can start playing with panels http://drupal.org/project/ to customize the layout of the entire site and check some of the themes in http://drupal.org/project/Themes to change the look&feel of your site (you can also go with pure css)
I hope it helps. If you want to add another feature to this solution or something isn't clear enough please let me know.
Cheers!
Apache Lenya 可以工作。您必须编写自己的身份验证机制和组管理代码来同步数据库中的用户。任何产品都会给您带来对抗专有数据库的困难。如果您能够将用户和组数据放入目录（例如 LDAP）中，您的问题就会变得容易得多。
Apache Lenya could work. You'd have to write your own authentication mechanism and group management code to sync over the users from the DB. Any product is going to give you difficulty going against a proprietary DB. If you were able to put the user and group data into a directory, say LDAP, your problem becomes a lot easier.
这实际上应该适合您。您可以为要管理的文件创建一个组，并在人员获得/失去对文件的访问权限时向该组添加/删除人员。
This should actually work for you. You can create a single group for the file you want to manage and add/remove people to that group as they gain/lose access to the file.
我不确定这是否能 100% 回答您的问题，但是我使用过 Daisy-cms作为一个文档管理系统。
使用 Daisy，您可以设置附件文档或您自己的文档类型。您无法创建文件夹，但您可以根据字段中的值进行访问（这是棘手的部分）。
它是开源的，易于安装到 MySQL，只需点击即可完成您想要执行的大部分操作。
希望这有帮助。
I am not sure if this answers 100% of your issues however I have used Daisy-cms as a document management system.
With Daisy you can setup Attachment documents or your own document types. You cannot create folders however you can have access (this is the tricky part) based on Values in the fields.
It's open source, simple to install against MySQL and point and click for most of what you want to do.
Hope this helps.
我找到了这些可能的解决方案：
即使它有一些错误，我选择了 Quotero，由于上述原因。它的可扩展性（相对于我需要的）让我感到惊讶。
我如何安装（在 Ubuntu Server 10 上的 Tomcat 6 和 Windows 7 上的 Tomcat 7 中）并将其与我的主 Web 应用程序集成：
org.coretechs.quotero.user.impl.AuthenticationSourceFoo（主类；它还处理域创建中要求的参数）org.coretechs.quotero.user.impl.factory.foo.FooUserFactory（与用户表交互）org.coretechs.quotero.user.impl.factory.foo.FooGroupFactory（与组表交互）org.coretechs.quotero.user.impl.factory.foo.FooDBManagerDB2（与数据库交互）org.coretechs.quotero.user.impl.factory.foo.FooPasswordHash（实现自定义密码哈希算法）这样您就可以使用属于主 Web 应用程序（或其他任何内容）的用户和组的帐户登录数据库中包含用户和组表的应用程序！）以及 Quotero DMS 的文件和文件夹的权限可以参考这些。其他数据，例如属于经典域的权限、文档、任务、工作流程、用户和组，将保留在 Quotero DB 中。 因此，您有 2 个数据库：一个用于整个 Quotero DMS，另一个（已经存在）用于 Quotero 检索用户和组（无需复制这些数据）。
编辑：
I不得不面对一些损害 Quotero 工作的错误...所以我不得不放弃这个解决方案。
I found these possible solutions:
Even if it has some bugs, I've choosen Quotero, for the above reasons. It's extensibility (relative to what I need) surprised me.
How I installed (in Tomcat 6 on Ubuntu Server 10 and Tomcat 7 on Windows 7) and integrated it with my main webapp:
org.coretechs.quotero.user.impl.AuthenticationSourceFoo(the main class; it handles also the parameters asked in domain creation)org.coretechs.quotero.user.impl.factory.foo.FooUserFactory(interacts with users table)org.coretechs.quotero.user.impl.factory.foo.FooGroupFactory(interacts with groups table)org.coretechs.quotero.user.impl.factory.foo.FooDBManagerDB2(interacts with the DB)org.coretechs.quotero.user.impl.factory.foo.FooPasswordHash(implements custom password hash algorithm)In this way you can log in with the accounts belonging to users and groups of your main webapp (or whatever application with users and groups tables in a DB!) and also permissions on files and folders of Quotero DMS can be referred to those ones. Other data, such as permissions, documents, tasks, workflows, user and groups belonging to classical domain, will remain in the Quotero DB. So you have 2 DB: one for the whole Quotero DMS and one (already existing) where Quotero retreives users and groups (no need to replicate these data).
EDIT:
I had to face some bugs that compromise the working of Quotero... so I had to abandon this solution.
我最终决定使用商业客户端-服务器 DMS 并在其之上构建一个 Web 应用程序来检索文档及其关系。文档访问控制由 DMS 管理，并提供用户名和密码。用户和组可以轻松添加到 DMS。这是基础设施：
I finally decided to use a commercial client-server DMS and built on top of it a webapp for retrieving documents and their relationships. Documents access control is managed by the DMS, given username and password. Users and groups can be easily added to the DMS. This is the infrastructure: