RelationalDBDesign
RedhatLinuxSys Seomining
prev next prev next
Course navigation
Lesson 1
Managing the password file
This module is about password files. Password files provide a mechanism for authenticating database administrators who connect remotely over a network. When you have completed this module, you should be able to do the following:
  1. Create a new password file
  2. Connect to a database as SYSDBA or SYSOPER
  3. Grant SYSDBA and SYSOPER privileges to DBAs
  4. Configure a database to use a password file
  5. Rebuild a password file
  6. Select from v$pwfile_users to see who has SYSDBA or SYSOPER privileges
Password files play an important role in database security, especially when you are using tools such as Oracle Enterprise Manager to remotely manage a database over a network.
Course navigation