Password file authentication for Oracle ASM can work both locally and remotely. To enable password file authentication, you must create a password file for Oracle ASM.
If you select the Oracle ASM storage option, then ASMCA creates a password file for Oracle ASM with initial users (SYS and ASMSNMP) when ASMCA configures the Oracle ASM disk groups. To add other users to the password file, you can use the CREATE USER and GRANT commands as described previously in the section titled "About Privileges for Oracle ASM".
If you configure an Oracle ASM instance without using ASMCA, then you must manually create a password file and grant the SYSASM privilege to user SYS.
SQL*Plus commands use password file authentication.
Oracle Database Administrator's Guide for information about creating and maintaining a password file
Oracle Database SQL Language Reference for information about the CREATE
USER
and GRANT
commands
Oracle Database Security Guide for information about database security
Oracle Database Reference for information about the V$PWFILE_USERS
view which lists users who have been granted SYSASM
, SYSDBA
, and SYSOPER
privileges as derived from the password file.