Re: grant problem

On Wed, Mar 23, 2005 at 12:09:33PM +0530, Rajarshi Mukherjee wrote:

> i am ony giving usage grant on a function in my schema  to another user.

I think you mean you're granting usage on the schema -- "USAGE"
isn't a valid privilege type for functions.

> Then how come he's been able to execute the function in the following way?
>
> select ins.validate('nyname','mypassword');

The default privilege for functions grants EXECUTE to PUBLIC, so if
you've granted USAGE on the schema then users can execute functions
in that schema.

> But if i don't give usage grant and straight way give execute grant on
> the function, the user gets an error:- permission denied for schema
> ins.

Users who don't have USAGE on the function's schema won't be able
to execute the function, regardless of the function's privileges.
Think of the schema as a container: if you don't have privilege on
the container, then you can't access anything inside the container.

> i want to give the user execute grant on a particular funtion in my
> schema and not all functions.

Grant USAGE on the schema, and revoke EXECUTE on the functions you
don't want people to execute.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/