Systemwalker Service Quality Coordinator User's Guide

9.1.1 How to create a new user that can access the Oracle dynamic performance view

Note

This operation is not required if the default ID and PASSWORD for Oracle are used.

To create a new user that can access the Oracle dynamic performance view, enter the following SQL command from svrmgr1 using an Oracle administrator ID (usually "system").

In the following example, the necessary privileges are given to a user with ID "id1" and password "pass1".

create user id1 identified by pass1;

grant dba to id1;

grant connect to id1;