Results 1 to 6 of 6

Thread: How to Encrypt Oracle Database File

  1. #1
    Join Date
    Feb 2010

    How to Encrypt Oracle Database File

    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.

  2. #2
    Join Date
    Feb 2008

    How to Encrypt Oracle Database File

    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:


  3. #3
    Join Date
    Jan 2008

    How to Encrypt Oracle Database File

    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.

  4. #4
    Join Date
    Apr 2008

    How to Encrypt Oracle Database File

    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


  5. #5
    Join Date
    May 2008

    Re: How to Encrypt Oracle Database File

    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.

  6. #6
    Join Date
    Apr 2008

    How to Encrypt Oracle Database File

    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.

Similar Threads

  1. How to Encrypt Database in PHP?
    By Emily123 in forum Software Development
    Replies: 5
    Last Post: 05-03-2010, 02:08 AM
  2. Control file error in oracle database
    By Gerri in forum Software Development
    Replies: 4
    Last Post: 01-02-2010, 08:45 PM
  3. Packages in oracle database
    By Garlands in forum Software Development
    Replies: 3
    Last Post: 30-01-2010, 02:55 PM
  4. Oracle database gives an missing comma message while saving file
    By StephanieRice in forum Windows Software
    Replies: 3
    Last Post: 12-08-2009, 10:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts