Can 'execute on utl_smtp' be granted to user role?
I have revoke the execute on utl_smtp from public. Now, i like to check if 'execute on utl_smtp' be granted to user role? Is it a norm to grant to a role, any implications?
I tried granting to my user role and it didn't report any failure. My program with that role and call the package utl_smtp also works without error.
However, i don't seems to be able to find the privilege granted to that role in my dba views table? Which dictionary table will show me the execute privilege granted to the role?
Thanks.