Granting the diagnostics System Role

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

Prerequisites

MANAGE ROLES system privilege.

Task

You can grant the diagnostics system role to other roles only with no administrative rights (WITH NO ADMIN OPTION clause). The WITH ADMIN OPTION and WITH ADMIN ONLY OPTION clauses are invalid for the diagnostics system role.

You can grant system privileges and roles to, and revoke them from, the diagnostics system role.

To grant the diagnostics system role, execute:

GRANT ROLE diagnostics TO grantee [,...]