Database Preparation
39
To create a non-owner database user account
1.
Log into SQL*Plus as SYSDBA
2.
Create a non-owner user. The following is an example command to
create a user. Replace <RUNUSER> with the name of the user and
<RUNUSERPASS> with the password.
CREATE USER <RUNUSER> PROFILE "DEFAULT"
IDENTIFIED BY <RUNUSERPASS>
DEFAULT TABLESPACE "ETM"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK;
3.
Grant privileges to the user account with the following commands
as an example. Replace <RUNUSER> with the name of the user.
GRANT ALTER SESSION TO <RUNUSER>;
GRANT CREATE PROCEDURE TO <RUNUSER>;
GRANT CREATE SESSION TO <RUNUSER>;
GRANT CREATE <SNAPSHOT_PERM> TO <RUNUSER>;
GRANT CREATE TABLE TO <RUNUSER>;
GRANT CREATE VIEW TO <RUNUSER>;
GRANT UNLIMITED TABLESPACE TO <RUNUSER>;
To associate a data instance with a Management Server
1.
In the ETM Database Maintenance Tool, while connected to the ETM
Standalone Database, right-click the correct data instance, and then
click
Set as default
.
The Set Default ETM Instance
dialog box
appears.
Non-owner
Database
Account
Associate a Data
Instance with
Management
Server
