Monday, July 7, 2014

Grant DBADM Privilege

1. Connect to DB
db2 => connect reset
DB20000I  The SQL command completed successfully.
db2 => connect to dmdb

   Database Connection Information

 Database server        = DB2/NT64 10.1.4
 SQL authorization ID   = ADMINIST...
 Local database alias   = DMDB


2. Grant privilege
db2 => grant dbadm on database to user db2admin
DB20000I  The SQL command completed successfully.
db2 =>

No comments:

Post a Comment