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:

      create user <UserName> identified by Password

       grant sysdba to <UserName>

      or

      grant sysasm to <UserName>

  2. When you create the ASM connection in the configuration window, specify the and the SYSDBA or SYSASM role.