DEVFYI - Developer Resource - FYI

How does one add users to a password file? (for DBA

ORACLE Interview Questions and Answers (Part 2)


(Continued from previous question...)

195. How does one add users to a password file? (for DBA

One can select from the SYS.V_$PWFILE_USERS view to see which users are listed in the password file. New users can be added to the password file by granting them SYSDBA or SYSOPER privileges, or by using the orapwd utility. GRANT SYSDBA TO scott;

(Continued on next question...)

Other Interview Questions