I.1 When the sp_rist.sql script is executed
The following table lists the system privileges needed for the Oracle account executing the sp_rist.sql script.
Privileges required |
Description |
---|---|
CREATE SESSION |
Required when a session is established for the monitored Oracle Database. |
CREATE TABLE |
Required when a table#1 required to monitor the monitored Oracle Database is registered. |
CREATE PROCEDURE |
Required when a procedure#1 required to monitor the monitored Oracle Database is registered. |
SELECT ANY DICTIONARY |
Required when information#1 required to monitor the monitored Oracle Database is registered. |
UNLIMITED TABLESPACE |
Required when information#1 required to monitor the monitored Oracle Database is registered#2. |
- #1
-
See the following tables.
- In Windows
-
In 2.1.4(4)(c) Registering objects in the Oracle Database, see Table 2-11
- In UNIX
-
In 2.2.4(4)(c) Registering objects in the Oracle Database, see Table 2-24
For details about the CREATE TABLE privilege, see Table 2-11 or Table 2-24. For details about the CREATE PROCEDURE privilege, see the corresponding package.
- #2
-
This privilege is not needed when the assignment limit that allows writing to the default tablespace of the account used for monitoring has been set.