Posted Tue, 02 Oct 2018 09:18:28 GMT by Aelita Zabrodina

We would like to check notification permissions  within our Docuware 6.11.
Is there an SQL statement we could use to show all Administrators and Subscribers for every notification in the system?

Posted Tue, 02 Oct 2018 12:46:37 GMT by Joe Kaufman Bell Laboratories Inc Senior System Architect

I am wondering the same thing now that I have looked over the data model. Looks like the dwsystem.DWNotificationSettings table has the notification information, and dwsystem.DWFCNotificationRules has the rules related to those notifications. But I cannot find a linkage to User or Role permissions anywhere...

It would be good to know this, as we periodically run queries to make sure one of our power users (who has some admin privileges) is keeping the App Dev department included in any new notifications created. Otherwise entire task flows are being put into place without us even knowing about it, and we can't always make sure things are making sense from a design perspective.

 

Thanks,

Joe Kaufman

You must be signed in to post in this forum.