Title: RE: Works interactively but not in procedure
This is a privilege issue. The stored proc runs with the security of the connected user except for those inherited via roles. Try adding the pragma for current user as follows to see if this is what you want:
CREATE OR REPLACE
procedure
Hello Tony,
I tried with 'authid current_user' and giving direct select to the user
'LOAD_MGR' but did not work..
Any other clue ?
Thanks for the time.
Nikunj
From: Aponte, Tony [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: RE: Works interactively
Title: RE: Works interactively but not in procedure
Can you verify the you issued GRANT SELECT ON SHIP_LOTS TO LOAD_MGR while connected as the owner of SHIP_LOTS? This should be enough to make it visible to LOAD_MGR via ALL_TAB_COLUMNS in a stored proc. Also, SELECT ANY TABLE would do but I
