In CAPC, we added NFA as a data source. As a result, the user permissions are set to None by default. How do we do a mass update on over 1000 users to grant User access?
How to globally modify Data Source access for Users without using the DX NetOps Performance Management Performance Center Portal.
All supported DX NetOps Performance Management releases
This is by design. When a new Data Source (DS) is added all users are set to None by default for access to the new DS. The exception is the default admin user.
Some DS's allow users with the None access level to view data in reports from the DS. Some require a minimum of User access level to the DS to view data in reports from that DS.
NFA is one that does allow users with the None access level to view data in reports for NFA Data. If that is sufficient the following changes are not necessary.
A new feature to add a new option was created in engineering which will add the ability to mass select users and add/change the DS access level at one time.
This command will update any User that with a Role other than Administrator assigned. It will update the Users NFA Data Source (DS) access level to 'User'.
We can see how many users there are, and how many would be changed with these commands:
The count from the data_source_rights table query (second one listed) should be >= to the count from the user_definitions table query (first one listed). It will depend on whether any Users with the Administrator Role were given User level NFA access.
Note: In the DB table data_source_rights that stores DS rights. The following UserLevel values are available.
To make this change via database commands complete the following steps.