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 rel服务器托管网oad affects privileges for each existing client session as follows:
Table and column privilege cha服务器托管网nges take effect with the client’s next request
服务器托管,北京服务器托管,服务器租用 http://www.fwqtg.net
机房租用,北京机房租用,IDC机房托管, http://www.fwqtg.net
相关推荐: Spring扩展接口(4):InstantiationAwareBeanPostProcessor
在此系列文章中,我总结了Spring几乎所有的扩展接口,以及各个扩展点的使用场景。并整理出一个bean在spring中从被加载到最终初始化的所有可扩展点的顺序调用图。这样,我们也可以看到bean是如何一步步加载到spring容器中的。 Instantiatio…