-- 查看存储过程定义
SHOW CREATE PROCEDURE procedure_name;

-- 授予只读权限（需要先有GRANT OPTION权限）
GRANT EXECUTE ON PROCEDURE db_name.procedure_name TO 'user'@'host';

-- 查看存储过程定义
SELECT OBJECT_DEFINITION(OBJECT_ID('schema_name.procedure_name'));

-- 授予只读权限
GRANT VIEW DEFINITION ON SCHEMA::schema_name TO username;

-- 查看存储过程定义
SELECT TEXT FROM ALL_SOURCE WHERE NAME = 'PROCEDURE_NAME' AND TYPE = 'PROCEDURE' ORDER BY LINE;

-- 授予只读权限
GRANT DEBUG ON schema_name.procedure_name TO username;

-- 查看存储过程定义
SELECT prosrc FROM pg_proc WHERE proname = 'procedure_name';

-- 授予只读权限
GRANT USAGE ON SCHEMA schema_name TO username;