Oracle授权函数权限给用户:
赋权:
grant execute on function1 to ucr_dtb1;
收回执行权限:
revoke execute on function1 from ucr_dtb1;
在ucr_dtb1用户下执行函数:
select exp_dtb1.function1('xxxxx') from dual;
Oracle授权表权限给用户:
语法:
grant [权限名(select|insert |update|delete|all)] on [表名] to [用户名]
例子:给user1授权查询table1的权限:
grant select on table1 to user1;