Viewing Database Password File Members

The V$PWFILE_USERS view contains information about users that have been granted administrative privileges.

qa testing training courses malaysiahttps://lernix.com.my/qa-testing-training-courses-malaysia/

To determine which users have been granted administrative privileges:

• Query the V$PWFILE_USERS view.

Removing a Database Password File

software development training courses malaysia

You can remove a database password file if it is no longer needed.

If you determine that you no longer require a database password file to authenticate users, then to remove it:

• Delete the database password file, and optionally reset the REMOTE_LOGIN_PASSWORDFILE initialization parameter to none.

it security training courses malaysia

After you remove this file, only those users who can be authenticated by the operating system can perform SYSDBA, SYSOPER, SYSBACKUP, SYSDG, or SYSKM database administration operations.

networking training courses malaysia