It can be difficult to know what is needed for a given Security Role to be created with the desired outcome.
Permissions and Privileges can be difficult to understand
This document is intended to provide information that will help make the permissions and privileges existing roles have more transparent. Making it possible to better understand what is needed for specific scenarios.
The following sections are provided to help here.
The attached file "Privileges and Permissions per role.xlsx" contains the following:
NOTE: There are filters at the top of each column that make it possible to limit the results to more usable amounts of data.
The following screenshot shows how easy it is to see the Management Privileges assigned to each role.
The attached "Security Matrix builder for Permissions and Privileges.sql" file has four sections, to see similar data for a different version or to include custom roles in the matrix