How to Encrypt Oracle Database File

[GracieSingh]

Hi buddies,

Oracle Relations Database have excellent performance of the system to obtain a wide range of apply and to ensure the security of the database that is a database management Work Important content. I want to the management of Oracle database security based on passwords on the Oracle database system file the creation, use and maintenance in detail. Check and reply.

[MindSpace]

Using the Oracle Instance Manager to create a database instance, in the ORACLE_HOME \ DATABASE directory is also automatically creates a corresponding password file, the file name PWDSID.ORA, where SID represents the corresponding Oracle database system identifier. This password file is a database management of the initial after this, the administrator can also if necessary, use a tool ORAPWD.EXE manually create a password file, the command format is as follows:

C: \> ORAPWDFILE = <FILENAME> PASSWORD = <PASSWORD> ENTRIES = <MAX_USERS>

[Modifier]

In the Oracle database instance initialization parameter file, this parameter controls the use of the password file and its state. It has the following options:
# NONE: Instructed Oracle system does not use a password file, the user's login privileges through operating system authentication.
# EXCLUSIVE:Indicates that only one database instance can use this password file. Only in this setting the password file can contain, inter INTERNAL / SYS other than the user information, which allows the system privileges SYSOPER / SYSDBA granted except INTERNAL / SYS other than the user.

[Praetor]

With the password file, users can use the password file to SYSOPER / SYSDBA privileges log on Oracle database instance, and pay attention REMOTE_LOGIN_PASSWORDFILE initialization parameter should be set to EXCLUSIVE or SHARED. Any user with SYSOPER / SYSDBA permissions to log in, will be located under the SYS user's Schema, the following two registry examples:
1. Log on to: Suppose user scott has been granted SYSDBA privileges, he can use the following command log:
CONNECTscott / tigerASSYSDBA

2. To INTERNAL log- CONNECT INTERNAL / INTERNAL_PASSWORD

[Katty]

You can protect the password file. You can view the password file in the members. You Can query the view V $ PWFILE_USERS to obtain ownership SYSOPER / SYSDBA system privileges of the user's information, the table SYSOPER / SYSDBA column values TRUE / FALSE means that the user has the appropriate permissions. These users is accordingly present in the password file members. check and reply.

[kelfro]

You can also modify the password file status. Password file status information stored in the document, when it is created, its default state of SHARED. By changing the initialization parameter can be set to change the password file REMOTE_LOGIN_PASSWORDFILE state. When you start the database instances when, Oracle systems from the initialization parameter file to read REMOTE_LOGIN_PASSWORDFILE parameter settings; when loading the database, the system password file this parameter and to compare the state, if different, then update the password file status. Best of luck.