Database -> Users

On this page you can define which Oracle users have access to database via APPM. From DBA perspective, APPM uses following database roles:

• APPM_USER_ROLE - allows to query performance-related data through APPM application. It does not allow to change any data or to perform any actions on database (e.g. killing or tracing database sessions)
• APPM_TRACE_ROLE - allows everything that APPM_USER_ROLE allows and also adds privilege to perform SQL Trace of any session.
• DBA or SYSDBA - user can also perform some critical actions through APPM (such as killing database sessions).

Table in screenshot shows list of database users. By clicking on columns USER and TRACE you can grant/revoke previously described APPM_USER_ROLE and APPM_TRACE_ROLE. You cannot grant DBA or SYSDBA through GUI.

Table is displaying data from dba_users view.