oracle中把函数的执行权限赋个某个用户

赋权:grant execute on function1 to ucr_dtb1;
收回执行权限:revoke execute on function1 from ucr_dtb1;

在ucr_dtb1用户下执行函数:

select exp_dtb1.function1('xxxxx') from dual;

原文地址:https://www.cnblogs.com/nizuimeiabc1/p/5245199.html