Granting privileges to non-SYS users for ASM instances

You must connect to ASM instances that are using the SYSDBA and SYSASM roles for users. If you do not want to use the SYS account to connect to ASM instances, create a user account and grant the SYSDBA and SYSASM roles to the account.

Procedure

  1. Run the following commands to create a user account and grant roles:
    • Log in to the ASM database with the SYSASM role to create a new user for an agent and grant the SYSDBA role or SYSASM role:
      1. create user UserName identified by Password
      2. grant sysdba to UserName
        or
        grant sysasm to UserName
  2. When you create the ASM connection in the configuration window, specify the UserName user and the SYSDBA or SYSASM role.
    Note: If you choose the SYSASM role to access the ASM database, you must configure the agent instance by using Oracle home or Oracle instant client to connect to the Oracle database.