Changing the Database Owner

To change the database owner

  1. Log in as the current dbowner.
  2. Run a dbmgr -backup
  3. At a command prompt enter:

    dbmgr -stop

    Removedb -rmdir sqmdb

  4. Log off the machine.
  5. Log on the machine as the person you want to be the new database owner.
  6. At a command prompt enter:

    dbmgr -new -sample sqmdb

  7. Restore the backup to this new sqmdb directory while logged in as this new owner.