Re: select user object privilege error ???
- From: Daniel Fink <daniel.fink@xxxxxxxxxxxxxx>
- To: mccdba1@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Sat, 22 Jan 2011 11:36:51 -0700
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@xxxxxxxxx> 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
>
>
>
>--
>//www.freelists.org/webpage/oracle-l
>
>
��i��0���zX���+�� n��{�+i�^
Other related posts:
