Re: how to grant select a table in a stored procedure scope
Posted by:
Rick James
Date: August 19, 2012 09:43PM
SHOW the relevant GRANTS.
Create another user (let's call him 'foo'). It would have the desired SELECT (etc) privileges for running the SP. Then
CREATE PROCEDURE DEFINER=foo ProcName(...)...
Then GRANT EXECUTE to your real user.
Subject
Views
Written By
Posted
2572
August 18, 2012 06:58AM
Re: how to grant select a table in a stored procedure scope
965
August 19, 2012 09:43PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.