privileges on functions

Question posted by: uwcssa@gmail.com (Guest) on July 2nd, 2008 06:05 PM

I created one function and wish to assign it to some users. however,
even though

"grant execute on function" succceeded, that user can still not use
it. i am wondering if
functions do not have transferable rights?

i am using v9.1. thanks

Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).

Dave Hughes

Guest

n/a Posts

July 3rd, 2008
01:15 AM
#2

Re: privileges on functions

Join Bytes! wrote:

Quote:

Originally Posted by

I created one function and wish to assign it to some users. however,
even though
>
"grant execute on function" succceeded, that user can still not use
it. i am wondering if
functions do not have transferable rights?
>
i am using v9.1. thanks

Assuming you committed the GRANT, the user should be able to execute
the function just fine. Are you sure they're executing your function
and not a similarly named function in a different schema? (or an
overloaded version of the function - though I assume that's not the
case as you explicitly stated "one" function)

Not sure what you mean by "transferable rights" though?

Cheers,

Dave.

--CELKO--

Guest

n/a Posts

July 3rd, 2008
11:45 AM
#3

Re: privileges on functions

Does the function do something for which the user does not have
privileges?

Not the answer you were looking for? Post your question . . .
184,055 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Latest Articles: Read & Comment

Didn't find the answer you were looking for?
Post Your Question

Top Community Contributors