Home » RDBMS Server » Server Administration » function with user
function with user [message #537892] Mon, 02 January 2012 09:26 Go to next message
windowsdos
Messages: 29
Registered: May 2011
Junior Member
hi
i have a user which include a function
and i connect with another user
and need this user to see a function of the first one
what is grant can i give it to this user?
Re: function with user [message #537893 is a reply to message #537892] Mon, 02 January 2012 09:37 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
EXECUTE.
Re: function with user [message #537894 is a reply to message #537892] Mon, 02 January 2012 09:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

log onto DB as function owner then do as below

GRANT EXECUTE ON FUNCTION_A TO OTHER_USER;
Re: function with user [message #537895 is a reply to message #537892] Mon, 02 January 2012 10:19 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As this is another question from you about GRANT statement, I advise you to read the documentation about this command -> here.
In the same time, I advise to read the whole Database SQL Reference.

Regards
Michel
Previous Topic: ORA-01555 during expdp
Next Topic: v$session (2 Merged)
Goto Forum:
  


Current Time: Thu Mar 28 19:57:22 CDT 2024