Granting diagnostics System Role

Members of the diagnostics role inherit SELECT, INSERT, UPDATE, DELETE, and ALTER privileges on diagnostic tables and views.

Prerequisites

Requires the MANAGE ROLES system privilege.

Task

The diagnostics system role is granted the MANAGE PROFILING system privilege with no administrative rights. By default, the diagnostics system role is granted to the SYS_AUTH_PROFILE_ROLE compatibility role with no administrative rights, and can be granted to other roles with no administrative rights only.

The WITH ADMIN OPTION or WITH ADMIN ONLY OPTION clauses are not valid when granting the diagnostics system role.

To grant the diagnostics system role, execute:

GRANT ROLE diagnostics TO grantee [,...]