OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » function with user

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

function with user [message #537892]

Mon, 02 January 2012 09:26

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?

Report message to a moderator

Re: function with user [message #537893 is a reply to message #537892]

Mon, 02 January 2012 09:37

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

EXECUTE.

Report message to a moderator

Re: function with user [message #537894 is a reply to message #537892]

Mon, 02 January 2012 09:38

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;

Report message to a moderator

Re: function with user [message #537895 is a reply to message #537892]

Mon, 02 January 2012 10:19

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Oct 31 22:30:30 CDT 2025