Category: Manage Users and Groups

A DXL script to identify users and groups in a DOORS database in various combinations. Included is the valuable List of users in groups Excel report

Managing Users and Groups

Although DOORS permits the database administrator to set up groups, unfortunately there are no in built report functions that let you understand, for example, which users are in what group, or the permissions a particular user has in a module.

This utility provides the DOORS database administrator with a series of very comprehensive reports. Most of the reports are simple text lists, displayed in the text console, with the data separated by tabs so that it can be directly copied into Excel.

A few of the reports ( marked with an (E) ) are very sophisticated and will export directly into an Excel worksheet including coloured backgrounds for specific functionality. Some of the more important uses are as follows:

  • Provide a list of the Users for ‘cut and paste’ into excel;
  • Provide a list of each group and the members in Excel;
  • If emails have been entered then provide a mailing list;
  • Extract the RMCDA access permissions for Users, Groups in each Module.
A utility to provide a listing of all Users and Groups within a DOORS database

The Excel listing of the groups and the members is worthy of specific mention as it is extremely useful in large projects where there are hundreds of users and groups. Here is an example listing:

An Excel output generated from all Users and Groups within a DOORS database
An Excel output generated from all Users and Groups within a DOORS database. Groups are listed across the top and there is a row for each user. Details of the user are listed and ‘X’ identifies whenever a user is in a group.