Database Security Products (MOSC)

MOSC Banner

MIssing Privilege When Trying To Execute Function on Another Schema

edited Jan 5, 2010 8:50AM in Database Security Products (MOSC) 4 commentsAnswered ✓
 Hi folks

I am tying to find out what privilege i need to execute a select statement using a function that was created by another schema owner and cannot figure what i need. Any assistance would be appreciated. I thought I had covered everything, but apparently not.

logged in as llprod_ro user exceuting on schema llprod

decode_subtype is function name

select subtype, llprod.decode_subtype(subtype) from llprod.dtree where rownum < 3;
                       *
ERROR at line 1:
ORA-01031: insufficient privileges

Thanks

Jim

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