Re: select user object privilege error ???

From: Daniel Fink <daniel.fink_at_optimaldba.com>
Date: Sat, 22 Jan 2011 11:36:51 -0700
Message-ID: <rsd4x80eq594x37km4p9qbow.1295721411351_at_email.android.com>



dbms_metadata in9i is less than...
It has been awhile since I worked on it, but I think the error is thrown if there is a missing option and has nothing to do with permissions. Check my site www.optimaldba.com for a paper and scripts for the trainwreck that is 9i dbms_metadata.

dba1 mcc <mccdba1_at_yahoo.com> wrote:

>We tried to use DBMS_METADATA.GET_GRANTED_DDL get user object privileges but get error. ORACLE version is 9.2.0.8 amd login as sys or system.
>
>any ideal?
>
>======================================================
>
>
>Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
>With the Partitioning, OLAP and Oracle Data Mining options
>JServer Release 9.2.0.8.0 - Production
>
>SQL> SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT', USERNAME) from dba_users;
>
>DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT',USERNAME)
>--------------------------------------------------------------------------------
>
> GRANT SELECT ON "SYSTEM"."MVIEW_WORKLOAD" TO "SYS" WITH GRANT OPTION
>
> GRAN
>
>
> GRANT ALTER ON "SYS"."INCEXP" TO "SYSTEM"
>
> GRANT DELETE ON "SYS"."INCEXP"
>
>
> GRANT EXECUTE ON "SYS"."OUTLN_PKG" TO "OUTLN"
>
>
>ERROR:
>ORA-31608: specified object of type OBJECT_GRANT not found
>ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
>ORA-06512: at "SYS.DBMS_METADATA", line 656
>ORA-06512: at "SYS.DBMS_METADATA", line 1378
>ORA-06512: at line 1
>
>
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>

i0zX+n{+i^ Received on Sat Jan 22 2011 - 12:36:51 CST

Original text of this message