Re: How to check owner of package

From: Reid Lai <reidlai_at_hk.super.net>
Date: 1997/08/20
Message-ID: <01bcad7b$52765280$1e1640ca@hk.super.net.hk.super.net>#1/1

SELECT OWNER FROM SYS.ALL_OBJECTS WHERE OBJECT_TYPE = 'PACKAGE' AND OBJECT_NAME = 'your_package_name';

Cezariusz Marek <Cezariusz.Marek_at_comarch.pl> wrote in article <33facb48.16897116_at_news.tpnet.pl>...
> Hi,
>
> How to check in package (at the runtime) who is the owner of it. The
> line:
>
> select user
> into v_usr
> from dual;
>
> gives me the user who executed package, not in who's schema it was
> created.
>
> Regards,
>
>
Received on Wed Aug 20 1997 - 00:00:00 CDT