Re: what grant should be given?

From: Jurij Modic <jmodic_at_src.si>
Date: Thu, 17 Sep 1998 09:31:06 GMT
Message-ID: <3600d4cc.11352546@news.siol.net>

On Thu, 17 Sep 1998 08:01:31 GMT, hpcheong_at_ncs.com.sg wrote:

>hi there,
>
>i need to grant a user so that he could run packages himeself with his
>account.
>
>what grant should that be?

GRANT EXECUTE ON package_name TO user_name; or
GRANT EXECUTE ON package_name TO role_name; (and grant this role to user)

Note that user will have to reference the package with the full name, including package owner
  (i.e.: owner_schema.package_name.procedure_or_function) unless a synonym for this package is available.

>thanks in advance
>
>rgds,
>evelyn.

HTH,
--
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Thu Sep 17 1998 - 04:31:06 CDT