Mysql OCP 16题

最新推荐文章于 2024-09-27 10:11:28 发布

hbhe0316

最新推荐文章于 2024-09-27 10:11:28 发布

阅读量123

点赞数

文章标签： python java 数据库 javascript php

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

版权

The following grants were executed:
GRANT CREATE ROUTING ON sales.* TO ‘webadmin’@’%’;
GRANT ALTER ON PROCEDURE sales.myproc TO ‘webadmin’@’%’;
A user successfully connects to the database as webadmin and created a stored procedure named get_reports.
The next day, the user logs in again as webadmin and wants to delete the stored procedure named get_reports, and therefore, issues the following statement:https://www.cndba.cn/hbhe0316/article/22755https://www.cndba.cn/hbhe0316/article/22755

USE sales;
DROP PROCEDURE IF EXISTS get_reports;https://www.cndba.cn/hbhe0316/article/22755 https://www.cndba.cn/hbhe0316/article/22755

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

What is the result of executing the statement?
A. The user will get an error because he or she did not use the ALTER statement to drop the stored procedure.
B. The user will get an error because he or she did not put the database name in front of the stored procedure name.
C. The stored procedure named get_reports will be dropped.
D. The user will get an error because he or she does not have the permission to drop stored procedures.
Answer: C
如果用户有 CREATE ROUTine(原题有误)权限并且建立了存储过程,则对该存储过程自动拥有删除和执行的权限,
当授予 create routine 时，自动授予 EXECUTE, ALTER ROUTINE 权限给它的创建者。可以使用{alter |drop} {procedure|function}

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

MYSQL