DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: .dmp Files

  1. 05-20-2005, 03:31 AM #1
    nametullah
    nametullah is offline Junior Member
    Join Date
    Feb 2003
    Location
    Pak
    Posts
    64

    .dmp Files

    The .DMP files can be import by every DBA user, is it possible that from which user i have export the data and got the BACKUP.DMP, can be import by only that user. For example ABC is a DBA, He has export the file of its user, now only he (ABC) can import the data from BACKUP.DMP, not by other DBAs.

    Nametullah kalair
    Always Remember Power is Your.
    Reply With Quote Reply With Quote
  2. 05-20-2005, 03:32 AM #2
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    hi

    Yes if a user x has exported it he can also import it.

    regards
    Hrishy
    Reply With Quote Reply With Quote
  3. 05-20-2005, 03:34 AM #3
    nametullah
    nametullah is offline Junior Member
    Join Date
    Feb 2003
    Location
    Pak
    Posts
    64
    But other DBAs can import the BACKUP.DMP. I need that only ABC can import that file, no one else cannot import it?
    Always Remember Power is Your.
    Reply With Quote Reply With Quote
  4. 05-20-2005, 04:33 AM #4
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Nope DBA is like GAWD :-) what you are trying to do is not possible.The data in the import dump is binary anyway so dba's would be able to make sense of it unless they are trying to crack it.

    what are you trying to achieve by the way ?

    regards
    Hrishy
    Reply With Quote Reply With Quote
  5. 05-20-2005, 05:17 AM #5
    nametullah
    nametullah is offline Junior Member
    Join Date
    Feb 2003
    Location
    Pak
    Posts
    64
    I get backups of the database by Exporting users. And there are others DBAs also for their users. For security purpose i was trying to ristrict other DBAs to import the data from my Exporting Files.
    Always Remember Power is Your.
    Reply With Quote Reply With Quote
  6. 05-20-2005, 05:27 AM #6
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Originally posted by nametullah
    I get backups of the database by Exporting users. And there are others DBAs also for their users. For security purpose i was trying to ristrict other DBAs to import the data from my Exporting Files.
    Not a good strategy you should be using RMAN for backups.

    regards
    Hrishy
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width