Roles and permissions
Related topics
The following lists the user roles for BMC AMI SQL Assurance for Db2 and describes their typical tasks:
| Role | Description |
|---|---|
| Db2 System Programmer (SYSPROG) | As the Db2 system programmer, you are responsible for installing and configuring the backend mainframe components required to support BMC AMI SQL Assurance for Db2:
|
| z/OS SYSPROG | As the z/OS SYSPROG, you install and configure z/OSMF and related BMC infrastructure components like user interface middleware (UIM) or common interface server (CIS) to enable integration with SQL Assurance. |
| z/OS Security Administrator | As the z/OS security administrator, you work with the z/OS system programmer to plan and implement ESM user IDs, initial passwords, and password policies. You authorize access to z/OSMF resources, manage RACF/ACF2/Top Secret profiles, define SAF resource classes, configure SSL certificates, and ensure compliance with enterprise security standards. |
| Linux Administrator | As the Linux administrator, you handle the installation of SQL Assurance plugins and applications. You download and unzip installation files from the BMC EPD site, install Jenkins HPIs or manage Universal Connector containers implementation, and assist in SSL certificate configuration. |
| Db2 DBA | As the Db2 DBA, you support the product by reviewing SQL analysis results, creating SQL Assurance rules and reviewing SQL violations for compliance. |
| CI/CD Pipeline Engineer | As the DevOps engineer, you configure CI/CD projects and pipelines to integrate SQL evaluation into automated development workflows. |
| Application Developer | As the application developer, you run CI/CD projects and pipelines to evaluate SQL quality, submit jobs through supported tools, and review evaluation results to ensure performance and compliance. |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*