Oracle database permission for using with Management

Use the code below to set up permissions for an Oracle database for these management schema:

• nastel_apwmq
• nastel_permv3

CREATE USER <id>
  IDENTIFIED BY <password>
  DEFAULT TABLESPACE <tablespace>
  TEMPORARY TABLESPACE <temp tablespace>
  ACCOUNT UNLOCK;


GRANT CONNECT TO NASTEL;

GRANT ALTER ANY INDEX TO <id>;
GRANT ALTER SESSION TO <id>;
GRANT CREATE ANY INDEX TO <id>;
GRANT CREATE PROCEDURE TO <id>;
GRANT CREATE SEQUENCE TO <id>;
GRANT CREATE SESSION TO <id>;
GRANT CREATE TABLE TO <id>;
GRANT CREATE TRIGGER TO <id>;
GRANT CREATE VIEW TO <id>;
GRANT DROP ANY INDEX TO <id>;
GRANT UNLIMITED TABLESPACE TO <id>;

ALTER USER USERNAME QUOTA UNLIMITED ON <tablespace>;