How to grant SYSADM privileges to user db2admin ?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • melissa24
    New Member
    • May 2010
    • 1
    #1

    How to grant SYSADM privileges to user db2admin ?

    I have installed IBM DB2 UDB V 7.2. The default user id created was db2admin. But when I try to restore database from another db serv, I get an error saying SYSADM authority is required to perform this task.

    Can someone please help?
    Tags: None
    • Amarnath Reddy N
      New Member
      • May 2010
      • 11
      #2
      Originally posted by melissa24
      I have installed IBM DB2 UDB V 7.2. The default user id created was db2admin. But when I try to restore database from another db serv, I get an error saying SYSADM authority is required to perform this task.

      Can someone please help?
      use 'grant' command to give SYSADM privileges to user db2admin

      $db2 grant SYSADM to db2admin

        Comment

        Previous template Next
        Working...