关于mes系统中itguy帐号的产生过程

zhgc

创建帐号
CREATE USER 'itguy'@'%' IDENTIFIED BY 'itguy' ;

基本权限：
GRANT SELECT ON MYSQL.PROC TO  'itguy'@'%';
GRANT EXECUTE, CREATE ROUTINE, ALTER ROUTINE ON `sfc`.* TO  'itguy'@'%';

这样itguy就可以定义自己的SP

1. DELIMITER $
   
2. 
   
3. DROP PROCEDURE IF EXISTS `sfc`.`itguy_test`$
   
4. 
   
5. CREATE DEFINER=`itguy`@`%` PROCEDURE `itguy_test`()
   
6. BEGIN
   
7. 
   
8. set @h:=418;
   
9. 
   
10. END$
    
11. 
    
12. DELIMITER ;

复制代码

zhgc

CREATE USER 'itguy'@'%' IDENTIFIED BY '123456-!!' ;

GRANT SELECT ON MYSQL.PROC TO  'itguy'@'%';
GRANT EXECUTE, CREATE ROUTINE, ALTER ROUTINE ON `sfc`.* TO  'itguy'@'%';
grant select  on `sfc`.* TO  'itguy'@'%';

GRANT EXECUTE, CREATE ROUTINE, ALTER ROUTINE ON `smt`.* TO  'itguy'@'%';
grant select  on `smt`.* TO  'itguy'@'%';

syant

给itguy可以看information_schema.PROCESSLIST的权限
及可以kill pid的权限
GRANT SELECT, PROCESS, SUPER ON *.* TO 'itguy'@'%' IDENTIFIED BY PASSWORD '*2902971EC045E1FF45F5294C20F7D33977A298E7';

syant

似乎下面的方法并不可以一次收回所有权限

1. REVOKE ALL PRIVILEGES ON *.* FROM 'itguy'@'%';
   
2. FLUSH PRIVILEGES;

复制代码