Choose the best answer.
You encountered an insufficient privilege error in the middle of a long transaction.
您在长事务中遇到了不足的权限错误。
The database administrator is informed and immediately grants the required privilege:
通知数据库管理员并立即授予所需的权限：
GRANT UPDATE ON world.city TO 'user1' ;
How can you proceed with your transaction with the least interruption?
你如何以最少的中断继续你的交易？
A) Close the connection, reconnect, and start the transaction again.
B) Re-execute the failed statement in your transaction.
在事务中重新执行失败的语句。
C) Roll back the transaction and start the transaction again in the same session.
D) Change the default database and re- execute the failed statement in your transaction.
Answer:B If you modify the grant tables indirectly using an account-management
statement, the server notices these changes and loads the grant tables into memory again
immediately.
A grant table reload affects privileges for each existing client session as follows:
Table and column privilege changes take effect with the client's next request
标签：8.0,transaction,again,grant,125,statement,privilege,OCP,your From： https://blog.51cto.com/u_16049762/8889998