OraFAQ Forum: SQL & PL/SQL » execute permissions

Home » SQL & PL/SQL » SQL & PL/SQL » execute permissions

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

execute permissions [message #784]

Mon, 04 March 2002 08:03

Dmitry
Messages: 7
Registered: December 2001

Junior Member

Hi,
I was wondering if there was a way to check to see if a function has execute permission. I have a function in the "sys" schema and it works fine from there but when I try to call it from another user's account it doesnt work even though I granted ( or thuoght I did) execute permissions to the other user. Is there a way to error check this somehow?
Thanks in advance,
-Dmitry

Report message to a moderator

Re: execute permissions [message #795 is a reply to message #784]

Tue, 05 March 2002 00:50

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

see all_tab_privs and dba_tab_privs views

select grantee
from dba_tab_privs
where table_name=YOUR_FUNCTION_NAME

Report message to a moderator

Previous Topic:	deleting rows having even rownum
Next Topic:	Find double ...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 01:36:47 CDT 2024