Re: DBMS_METADATA.GET_DDL fails even though I have select privs. Can only use it with DBA privs or on a schema you have u/n and p/w for?
From: <dana_at_work_at_yahoo.com>
Date: Thu, 19 Mar 2009 13:15:03 -0700 (PDT)
Message-ID: <0f861d8c-3421-40c3-9f7a-25babcb7a669_at_b16g2000yqb.googlegroups.com>
On Mar 19, 9:43 am, gar..._at_jamms.org wrote:
> From the 10gR2 documentation:
>
> http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_meta...
>
> "Nonprivileged users can see the metadata of only their own objects."
>
> HTH
Thanks. That explains it.
Date: Thu, 19 Mar 2009 13:15:03 -0700 (PDT)
Message-ID: <0f861d8c-3421-40c3-9f7a-25babcb7a669_at_b16g2000yqb.googlegroups.com>
On Mar 19, 9:43 am, gar..._at_jamms.org wrote:
> From the 10gR2 documentation:
>
> http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_meta...
>
> "Nonprivileged users can see the metadata of only their own objects."
>
> HTH
Thanks. That explains it.
Dana Received on Thu Mar 19 2009 - 15:15:03 CDT