Database Security Products (MOSC)

MOSC Banner

Can 'execute on utl_smtp' be granted to user role?

edited Oct 8, 2009 4:50PM in Database Security Products (MOSC) 3 commentsAnswered
Hi all,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center