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

By default, the diagnostics system role is granted the SYS_AUTH_PROFILE_ROLE compatibility role with no administrative rights and the MANAGE PROFILING system privilege with administrative rights only.

It is a member of the PUBLIC system role with no administrative rights only.

The diagnostics system role can be granted to other roles with no administrative rights only (WITH NO ADMIN OPTION clause). The WITH ADMIN OPTION and WITH ADMIN ONLY OPTION clauses are not valid for this role.

To grant the diagnostics system role, execute:

GRANT ROLE diagnostics TO grantee [,...]