Mysql OCP 56题

最新推荐文章于 2024-08-26 18:14:37 发布

hbhe0316

最新推荐文章于 2024-08-26 18:14:37 发布

阅读量180

点赞数

文章标签： MySQL 权限管理 GRANT语句立即生效数据库访问

本文链接：https://blog.csdn.net/hbhe0316/article/details/122701017

版权

You are contacted by a user who does not have permission to access a database table. You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.
Which statement describes the activation of that access for the user?
A. The access does not take effect until the user logs out and back in.
B. The access does not take effect until the next time the server is started.
C. The access is available immediately.
D. The access does not take effect until you issue the FLUSH PRIVILEGES statement.
Answer: C

https://www.cndba.cn/hbhe0316/article/22796

https://www.cndba.cn/hbhe0316/article/22796 https://www.cndba.cn/hbhe0316/article/22796

一个用户联系到你，说他没有权限访问某张表，于是你执行了GRANT语句给其赋权。关于此用户的连接的权限，下面说法正确的是：
A．新的权限不会在现有连接上生效，直到重新登录才行
B．新的权限不会在现有连接上生效，直到重启mysqld才行
C．立即生效
D．新的权限不会在现有连接上生效，直到执行了FLUSH PRIVILEGES语句才行https://www.cndba.cn/hbhe0316/article/22796 https://www.cndba.cn/hbhe0316/article/22796 https://www.cndba.cn/hbhe0316/article/22796https://www.cndba.cn/hbhe0316/article/22796

MYSQL