Home » RDBMS Server » Security » Security of .DMP file (Oracle 10g)
Security of .DMP file [message #531038] Sat, 12 November 2011 01:25 Go to next message
babuctg9
Messages: 2
Registered: November 2011
Location: Bangladesh
Junior Member
Hi,

I have a software developed in oracle 6i and oracle database 10g.
I take backup everyday from my software and every day creates a backup file like 'siam_29-11-2011.dmp'. If I face any database related problem then I just delete the user and create another one by same name and import the backup file again into any new user.

But the problem is I am worried about the security of this data file,Because if any one want they can import this file easily into and can hake my data.

Now my question is what is the solution to safe the file from an unauthorized person who will not be able to import this file without any userid/Password or anything else.

For note:

When I import this file I use this type of command:-

After connecting to the user 'system'

1. SQL> Create user aaa identified by aaa;
2. SQL> Grant dba to aaa;
3. SQL> conn aaa/aaa
4. import the file.

Pls if any good solution help me.
Re: Security of .DMP file [message #531040 is a reply to message #531038] Sat, 12 November 2011 02:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no protection against dmp file theft.
You can encrypt it using an OS tool then the file will be useless.

Regards
Michel
Re: Security of .DMP file [message #531084 is a reply to message #531040] Sun, 13 November 2011 03:34 Go to previous messageGo to next message
babuctg9
Messages: 2
Registered: November 2011
Location: Bangladesh
Junior Member
Can I protect the .DMP file by giving any privileges.
Re: Security of .DMP file [message #531085 is a reply to message #531084] Sun, 13 November 2011 03:39 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Only a DBA can import a dump file made by a DBA.
But if the file is stolen, then it can be imported in any database.
For instance, if I steal your file I can import it in my database on which I have all privileges.

Regards
Michel
Previous Topic: user access the database
Next Topic: I have forgot my password
Goto Forum:
  


Current Time: Thu Mar 28 11:43:06 CDT 2024