granting execute on stored procedure

From: Sheehan, Jeremy <JEREMY.SHEEHAN_at_nexteraenergy.com>
Date: Mon, 26 Jan 2015 18:55:35 +0000
Message-ID: <939730CDCC52DA43AB03D00E4C678B9C2E8244FF_at_GOXSA1707.fplu.fpl.com>



Hello,

I’m working with our compliance officer on how to respond to a question posed to us by Internal Audit (helloooo Audit Season!).

What we’re looking at is execute privs that have been granted to some users. We found quite a few stored procedures that have been granted to some users, but I’m unclear if these will actually make a different or not due to invoker rights.

My question is this. If a stored procedure is created without using AUTHID CURRENT_USER/DEFINER, it runs as the SCHEMA OWNER, correct?

Please let me know and thanks in advance,

Jeremy

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 26 2015 - 19:55:35 CET

Original text of this message