Grant to allow users to enable/disable server tracing for application
profiling.
Prerequisites
Administrative privilege over SYS_AUTH_PROFILE_ROLE.
Task
You can grant this role with or without administrative
rights. When granted with administrative rights, a user can manage (grant and
revoke) the role, as well as use any of the underlying system privileges. When
granted with administrative rights only, a user can manage the role, but not use its
underlying system privileges. Finally, when granted with no administrative rights, a
user can only use its underlying system privileges. By default, the
SYS_AUTH_PROFILE_ROLE is granted the diagnostics system role with no administrative
rights.
To grant the SYS_AUTH_PROFILE_ROLE role, execute one of the following
statements:
| Administrative Option |
Statement |
|---|
| With full administrative rights |
GRANT ROLE SYS_AUTH_PROFILE_ROLE TO
user_ID
WITH ADMIN OPTION
|
| With administrative rights only |
GRANT ROLE SYS_AUTH_PROFILE_ROLE TO
user_ID
WITH ADMIN ONLY OPTION
|
| With no administrative rights |
GRANT ROLE SYS_AUTH_PROFILE_ROLE TO
user_ID
WITH NO ADMIN OPTION
|
Example:
This example grants the SYS_AUTH_PROFILE_ROLE to Mary, with administrative
options.
GRANT ROLE SYS_AUTH_PROFILE_ROLE TO Mary WITH ADMIN OPTION