Allows users to enable or 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, you
can manage (grant and revoke) the role, as well as use any of the underlying system
privileges. When granted with administrative rights only, you can manage the role,
but not use its underlying system privileges. Finally, when granted with no
administrative rights, you 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 rights.
GRANT ROLE SYS_AUTH_PROFILE_ROLE TO Mary WITH ADMIN OPTION