给SP赋权限

关键字： 工具技师 DB2

查看权限

查看表权限

select * from syscat.TabAuth where TabName = 'XXX'

查看SP权限

select * from syscat.RoutineAuth where SpecificName = (
  select SpecificName from syscat.Routines where RoutineName = 'XXX'
)

修改权限

grant execute on procedure [SP NAME] to group $GROUP_ID;
grant execute on procedure [SP NAME] to user $USER_ID with grant option;

grant execute on function [FN NAME] to group $GROUP_ID;
grant execute on function [FN NAME] to user $USER_ID with grant option;
redraiment： 一些DB2的使用技巧