Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to Encrypt Oracle Database File

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 27-02-2010
Member
 
Join Date: Feb 2010
Posts: 531
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.

Reply With Quote
  #2  
Old 27-02-2010
Member
 
Join Date: Feb 2008
Posts: 1,845
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:

Code:
C: \> ORAPWDFILE = <FILENAME> PASSWORD = <PASSWORD> ENTRIES = <MAX_USERS>
Reply With Quote
  #3  
Old 27-02-2010
Member
 
Join Date: Jan 2008
Posts: 1,515
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.
Reply With Quote
  #4  
Old 27-02-2010
Member
 
Join Date: Apr 2008
Posts: 1,947
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

2. To INTERNAL log- CONNECT INTERNAL / INTERNAL_PASSWORD
Reply With Quote
  #5  
Old 27-02-2010
Member
 
Join Date: May 2008
Posts: 2,007
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.
Reply With Quote
  #6  
Old 27-02-2010
Member
 
Join Date: Apr 2008
Posts: 2,000
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to Encrypt Oracle Database File"
Thread Thread Starter Forum Replies Last Post
How to Encrypt Database in PHP? Emily123 Software Development 5 05-03-2010 01:08 AM
Control file error in oracle database Gerri Software Development 4 01-02-2010 07:45 PM
Packages in oracle database Garlands Software Development 3 30-01-2010 01:55 PM
Oracle database gives an missing comma message while saving file StephanieRice Windows Software 3 12-08-2009 09:37 AM


All times are GMT +5.5. The time now is 10:17 PM.