By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,919 Members | 1,043 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,919 IT Pros & Developers. It's quick & easy.

How to grant SYSADM privileges to user db2admin ?

P: 1
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?
May 8 '10 #1
Share this Question
Share on Google+
1 Reply


P: 11
@melissa24
use 'grant' command to give SYSADM privileges to user db2admin

$db2 grant SYSADM to db2admin
May 19 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.