I. Questions:
Dbvisualizer: SQLCODE=-551, SQLSTATE=42501, SQLERRMC= user name; SELECT; The name of the table
Use software
Dbvisualizer software
Iii. Solutions (Windows system) :
Db2 Grant DBADM on Database to User user name
Reprint address: http://www.bubuko.com/infodetail-3002569.html
Reprint address 2:https://www.cnblogs.com/clfonly1/p/10613487.html
Dbvisualizer: SQLCODE=-551, SQLSTATE=42501, SQLERRMC= user name; SELECT; The name of the table
Use software
Dbvisualizer software
Iii. Solutions (Windows system) :
Db2 Grant DBADM on Database to User user name
Reprint address: http://www.bubuko.com/infodetail-3002569.html
Reprint address 2:https://www.cnblogs.com/clfonly1/p/10613487.html
Read More:
- Solve a bug harvest of DB2 (sqlcode = – 805, sqlstate = 51002, error message = DB2 SQL error: sqlcode = – 805, sqlstate = 5100
- DB2, create stored procedure error, sqlcode = – 104, sqlstate = 42601, PSM_ semicolon
- DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;;,?,?,?,?,?,?,?,?);END-OF-STATEMENT
- DB2 SQL error: sqlcode = – 803, sqlstate = 23505, sqlerrmc = 2 [solution]
- DB2 SQL error: SQLCODE: -433, SQLSTATE: 22001, SQLERRMC
- DB2 SQL error: sqlcode = – 433, sqlstate = 22001 solved
- DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703
- Error when connecting to database: DB2 SQL error: sqlcode = – 204, sqlstate = 42704, sqlerrmc= YXUAT.CUST_ BLK_ REL, DRIVER=4.25.13
- DB2 SQL ERROR: SQLCODE=-803, SQLSTATE=23505, SQL
- DB2 encountered the problem of sqlcode = 911 lock table when updating record update
- SQL Error: 1452, SQLState: 23000
- SQL Error: 17059, SQLState: 99999
- Using the TP framework, an error is reported sqlstate [08004] [1040] too many connections
- SQL Error: 904, SQLState: 42000
- SQL error: 17006, sqlstate: 99999 invalid column name
- SQL Error: 0, SQLState: 08S01 & Communications link failure
- [MySQL]SQLSTATE[HY000] [2002] No such file or directory
- How to Fix SQL Error: 1054, SQLState: 42S22 Unknown column ‘markcardex0_.art_service_time’ in ‘field list’
- SQL error: 156, sqlstate: S1000 error encountered in Hibernate
- ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS sqlState