Skip to main content
SnapManager for SAP

Create an Oracle user for the target database

Contributors
PDFs

You need to create an Oracle user with the sysdba role that connects to the database and performs database operations.

About this task

SnapManager can use any Oracle user with sysdba privileges that exists in the target database, for example, the default "sys" user. You can also create a user in the target database to be used exclusively by SnapManager.

Steps

  1. Log in to SQL *Plus.

    At the command prompt, enter the following command:

    sqlplus '/ as sysdba'

  2. To create a user, for example smsap_oper with the administrator password, for example, adminpw1, enter the following command at the SQL prompt:

    SQL> create user smsap_oper identified by adminpw1;

  3. Grant sysdba privileges to the Oracle user by entering the following command:

    SQL> grant sysdba to smsap_oper;