如下是當前用戶的權限，需要添加直接權限DBADM。但提示出錯，提示的TM_MGMDB.TMMGMDB未定義是什么意思？tm_mgmdb是當前用戶，tmmgmdb是連接的資料庫。
db2 => grant dbadm on tmmgmdb to tm_mgmdb
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0204N "TM_MGMDB.TMMGMDB" is an undefined name. SQLSTATE=42704
db2 => get authorizations
Administrative Authorizations for Current User
Direct SYSADM authority = NO
Direct SYSCTRL authority = NO
Direct SYSMAINT authority = NO
Direct DBADM authority = NO
Direct CREATETAB authority = NO
Direct BINDADD authority = NO
Direct CONNECT authority = NO
Direct CREATE_NOT_FENC authority = NO
Direct IMPLICIT_SCHEMA authority = NO
Direct LOAD authority = NO
Direct QUIESCE_CONNECT authority = NO
Direct CREATE_EXTERNAL_ROUTINE authority = NO
Direct SYSMON authority = NO
Indirect SYSADM authority = YES
Indirect SYSCTRL authority = NO
Indirect SYSMAINT authority = NO
Indirect DBADM authority = NO
Indirect CREATETAB authority = YES
Indirect BINDADD authority = YES
Indirect CONNECT authority = YES
Indirect CREATE_NOT_FENC authority = NO
Indirect IMPLICIT_SCHEMA authority = YES
Indirect LOAD authority = NO
Indirect QUIESCE_CONNECT authority = NO
Indirect CREATE_EXTERNAL_ROUTINE authority = NO
Indirect SYSMON authority = NO
uj5u.com熱心網友回復：
已解決，不能結貼。。。uj5u.com熱心網友回復：
grant dbadm on database to tm_mgmdb轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/89515.html
標籤：DB2
上一篇：按照型別，日期去統計，這個分組統計查詢該如何寫？？？
下一篇：navicat連資料庫詭異錯誤