對(duì)于mysql create routine權(quán)限的代碼案例詳細(xì)說(shuō)明

1、如果用戶有create routine 權(quán)限那么他就可以創(chuàng)建procedure function 。

2、如果用戶創(chuàng)建了procedure function 那么mysql 會(huì)自動(dòng)賦予它對(duì)procedure function 的alter routine和execute 權(quán)限。

3、例子：

用戶root用戶創(chuàng)建一個(gè)spuser@'localhost'用戶并對(duì)它賦予create procedure 權(quán)限

grant create routine on tempdb.* to spuser@'localhost' identified by '123456';

用spuser@'localhost'用戶去創(chuàng)建一個(gè)routine

delimiter go
create procedure sp_hello_world()
begin
  select 'hello world';
end 
go

delimiter ;

再一次查看spuser@'localhost'的權(quán)限

mysql> show grants;
+---------------------------------------------------------------------------------------------------------------+
  Grants for spuser@localhost                                           
+---------------------------------------------------------------------------------------------------------------+
  GRANT USAGE ON *.* TO 'spuser'@'localhost' IDENTIFIED BY PASSWORD '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9'  
  GRANT CREATE ROUTINE ON `tempdb`.* TO 'spuser'@'localhost'                           
  GRANT EXECUTE, ALTER ROUTINE ON PROCEDURE `tempdb`.`sp_hello_world` TO 'spuser'@'localhost'           
+---------------------------------------------------------------------------------------------------------------+

以上就是關(guān)于mysql create routine權(quán)限的代碼實(shí)例詳解的詳細(xì)內(nèi)容，更多請(qǐng)關(guān)注php中文網(wǎng)其它相關(guān)文章！