Automatically add security roles - Bring2mind

Site
Web

Bring2mind Forums

Forums
Search Forum
Advanced SearchTopicsPosts

Prev Go to previous topic

Go to next topic

Forums Document Exchange Lite Storage and Security

Last Post 06/20/2006 1:57 PM by Peter Donker

Automatically add security roles

1 Replies

Sort:


You are not authorized to post a reply.

Author

Messages

Christophe Borry

New Member
Posts:1

06/19/2006 5:55 PM
Hey, We would like certain employees to have 2 week to verify documents in DMX. After those 2 week the document should become available for all users. Therefor the 'all users' role should get view rights after two weeks automatically. Is it possible to 'simply' add a scheduled task that inserts lines in a 'view role' table with the right values? What table and values would that be? Help would be much appreciated, Christophe

Peter Donker

Veteran Member
Posts:4536

06/20/2006 1:57 PM
Sure you can. Look for 'ViewRoles' in DMX_Entries and set this to '-1;'. You'd want to check DateSubmitted to find out when the file was uploaded. You could do this easily with a single SQL query. Something like: UPDATE DMX_Entries SET ViewRoles = '-1;' WHERE DATEDIFF(day, DateSubmitted, GETDATE()) > 14 Something like that ... Peter

You are not authorized to post a reply.

Forums Document Exchange Lite Storage and Security

About Bring2mind

Bring2mind is the company of Peter Donker, a DotNetNuke enthusiast who has been involved with the platform from the very beginning. At the same time as the market for modules emerged, he realized there was no good document management solution for the platform yet and he set about creating this. In part he based the module on his experience with other document management systems he used while working as a researcher. His module, Document Exchange, was an instant success and has since become the premier document management solution for DotNetNuke. In 2004 he created Bring2mind as a vehicle for the module and is one of the few successful businesses solely based on a DotNetNuke product.

Contact Info

Please note we are located in Europe. Business hours are weekdays between 9 AM and 6 PM local time (Central European Time) which corresponds to 3 AM and noon EST.