2021/5/28 看到的权限数据：


SHOW GRANTS FOR report@'%';
GRANT CREATE TEMPORARY TABLES ON *.* TO 'report'@'%' IDENTIFIED BY PASSWORD '*8E2B5A8BF835E14935C5C7F3ADE1022CE13A371F';
GRANT SELECT ON `sfc`.* TO 'report'@'%';
GRANT EXECUTE ON PROCEDURE `sfc`.`kanban_01_xcah` TO 'report'@'%';
GRANT EXECUTE ON PROCEDURE `sfc`.`kanban_02_xcah` TO 'report'@'%';

usage
连接（登陆）权限，建立一个用户，就会自动授予其usage权限（默认授予）。
mysql> grant usage on *.* to ‘p1′@’localhost’ identified by ‘123′;
该权限只能用于数据库登陆，不能执行任何操作；且usage权限不能被回收，也即REVOKE用户并不能删除用户。

后来，发现又不行了：

1. 1 queries executed, 0 success, 1 errors, 0 warnings
   
2. 
   
3. 查询：CALL sfc.KANBAN_01_XCAH('3A')
   
4. 
   
5. 错误代码： 1370
   
6. execute command denied to user 'report'@'%' for routine 'sfc.KANBAN_01_XCAH'

复制代码

1.SHOW GRANTS FOR report@'%';
得到

1. GRANT CREATE TEMPORARY TABLES ON *.* TO 'report'@'%' IDENTIFIED BY PASSWORD '*8E2B5A8BF835E14935C5C7F3ADE1022CE13A371F'
   
2. GRANT SELECT ON `sfc`.* TO 'report'@'%'

复制代码

2.添加
GRANT EXECUTE ON PROCEDURE `sfc`.`KANBAN_01_XCAH` TO 'report'@'%'
FLUSH PRIVILEGES;

三层权限

GRANT ALL PRIVILEGES ON `sfc`.`b_po_config_t` TO 'report'@'%' WITH GRANT OPTION
GRANT
SELECT,INSERT, UPDATE, DELETE,
CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE VIEW, SHOW VIEW, TRIGGER
ON `sfc`.`b_pack_param_t` TO 'report'@'%' WITH GRANT OPTION

SP:
GRANT EXECUTE, ALTER ROUTINE ON PROCEDURE `sfc`.`ap_jz_change` TO 'report'@'%' WITH GRANT OPTION

二层权限：
GRANT ALL PRIVILEGES ON `smt`.* TO 'report'@'%' WITH GRANT OPTION

GRANT
SELECT,INSERT, UPDATE, DELETE,
CREATE, DROP, REFERENCES, INDEX, ALTER,
CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW,
CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER
ON `smt`.* TO 'report'@'%' WITH GRANT OPTION