OraFAQ Forum: Security » Security of .DMP file

Home » RDBMS Server » Security » Security of .DMP file (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Security of .DMP file [message #531038]

Sat, 12 November 2011 01:25

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.

Report message to a moderator

Re: Security of .DMP file [message #531040 is a reply to message #531038]

Sat, 12 November 2011 02:00

Michel Cadot
Messages: 68352
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

Report message to a moderator

Re: Security of .DMP file [message #531084 is a reply to message #531040]

Sun, 13 November 2011 03:34

babuctg9
Messages: 2
Registered: November 2011
Location: Bangladesh

Junior Member

Can I protect the .DMP file by giving any privileges.

Report message to a moderator

Re: Security of .DMP file [message #531085 is a reply to message #531084]

Sun, 13 November 2011 03:39

Michel Cadot
Messages: 68352
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

Report message to a moderator

Previous Topic:	user access the database
Next Topic:	I have forgot my password

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 08 00:31:50 CST 2023