I.1 When the sp_inst.sql script is executed
The following table lists the system privileges needed for the Oracle account executing the sp_inst.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(3)(b) Registering objects in the Oracle Database, see Table 2-10
- In UNIX
-
In 3.1.4(4)(b) Registering objects in the Oracle Database, see Table 3-14
For details about the CREATE TABLE privilege, see Table 2-10 or Table 3-14. 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.