11.2
For procedures, we need to grant EXECUTE privilege.
For example:
grant execute on scott.process_salary to john;
Lets say I have a function SCOTT.GET_EMPIDS and I want another user john to be able to invoke this fuction. So, what is the privilege that needs to be granted to John.
Is it SELECT or EXECUTE ?
grant select on SCOTT.GET_EMPIDS to john;
or
grant execution on SCOTT.GET_EMPIDS to john;