存储过程的权限
存储过程如何调用呢 ?
Call 存储过程名 ( 参数 1, 参数 2…)
问题 :
是否阿猫阿狗都可以随便调用存储过程呢 ?
不 , 能执行存储过程的帐户需要 execute routine 权限 . 如果系统参数
automatic_sp_privileges = 1 那么 execute routine 和 alter routine 权限
会随 create routine 权限而自动创建 .
其它 :
MySQL 帐户有 28 个如下权限 :select_priv, insert_priv, update_priv, delete_priv,
create_priv, reload_priv, shutdown_priv, drop_priv, process_priv, file_priv,
grant_priv, references_priv, index_priv, show_db_priv, alter_priv, super_priv,
create_tmp_table_priv, lock_tables_priv, execute_priv, repl_slave_priv,
repl_client_priv, create_view_priv, show_view_priv, create_routine_priv,
alter_routine_priv, create_user_priv, event_priv, trigger_priv
与权限相关的系统表 :
实表 :mysql.user, mysql.tables_priv, mysql.column_priv
虚表 :Information_schema.user_privileges,
nformation_schema.table_privileges, Information_schema.schema_privileges,
Information_schema.column_privileges
