In previous versions of Oracle, the "internal" or super-user account was limited
to one login / password. With Oracle 8, several IDs can be granted the internal
profile's capabilities. Using O/S password authentication is necessary as internal
users may need to get into server manager, and the instance may not be online.
Usage: orapwd file=<fname> password=<password> entries=<users>
file - name of password file (mand),
password - password for SYS and INTERNAL (mand),
entries - maximum number of distinct DBAs and OPERs (opt),
There are no spaces around the equal-to (=) character.
GRANT SYSDBA TO scott
In the inixx.ora file:
/* view accounts using external authentication */
SELECT name, sysdba, sysoper FROM V$PWFILE_USERS