Results 1 to 11 of 11
  1. #1
    Join Date
    Jul 2002
    Posts
    86

    Unanswered: Autorize for taking backup

    Hi All,
    I am working with db2v7.2 aix,
    I need to give authorize to 'DBBACKUP' userid to be able to take a backup JUST to take a backup and I am not happy to give them SYSMIANT authority, what should I do?

    Thanks

  2. #2
    Join Date
    Mar 2003
    Posts
    343
    Doesn't look like there's a lot of choice here. In oracle you can actually specifically regulate that and I kind of liked that.

  3. #3
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Don't know. According to the manual, the user that issues the BACKUP DATABASE command must have either sysadmin, sysctrl, or sysmaint authority. These obviously give more rights than backup.

    Why do you want that particular user to backup the database?
    Why not schedule periodic backups?

    Andy

  4. #4
    Join Date
    Jul 2002
    Posts
    86
    Originally posted by ARWinner
    Don't know. According to the manual, the user that issues the BACKUP DATABASE command must have either sysadmin, sysctrl, or sysmaint authority. These obviously give more rights than backup.

    Why do you want that particular user to backup the database?
    Why not schedule periodic backups?

    Andy
    Hi Andy,
    could you explaine what do you mean "not schedule periodic backups"?

    Thanks

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    See if this helps :

    http://catcode.com/teachmod/setuid.html


    Cheers

    Sathyaram

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I was asking a question. I will rephrase it.
    Are you scheduling periodic backups that happen automatically at specific times?
    Backups are done on our databases everynight around 10 PM. I scheduled it once and they continue to happen without intervention.
    When they are set up, you would supply the username and password for the backup process to use each time. To see what I mean, bring up the Control Center, hightlight the database you want to backup, right-click and pick backup. It should be obvious from there on how to schedule it.

    Andy
    Originally posted by David2002
    Hi Andy,
    could you explaine what do you mean "not schedule periodic backups"?

    Thanks

  7. #7
    Join Date
    Mar 2003
    Posts
    343
    I like the set uid idea though - I'm going to try and see if it works - because this would really idolate the userid from any other privileges.

  8. #8
    Join Date
    Jul 2002
    Posts
    86
    Originally posted by cchattoraj
    I like the set uid idea though - I'm going to try and see if it works - because this would really idolate the userid from any other privileges.
    Thank you all , it was really helpfull

  9. #9
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    David

    Can you let us know how you handled this ?


    cchattoraj, any luck with setuid ?

    Cheers

    Sathyaram

  10. #10
    Join Date
    Mar 2003
    Posts
    343
    I will be testing this week and will update this post when I'm done.

  11. #11
    Join Date
    Jul 2002
    Posts
    86
    Originally posted by cchattoraj
    I will be testing this week and will update this post when I'm done.
    I have not handled it yet , I am investigating about.

    Thank you for your follow up.

Posting Permissions

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