All,
Just have a quick question.. Our Application team currently use the view below to reference the object source ( at various places ) and with the new policy, we are not allowed to have access to SYS owned X$ views.
In other words, there was a view based on the code below to which the Application schema had access.. but under the new policy they cannot..
What are the equivalent views or options I have to get the same information ? I have given them the options of DBMS_METADATA or DBA_SOURCE or ALL_SOURCE..
They cannot use any of these.. Please anyone has any answer to this ?
Thanks
SELECT u.name
,o.name
,DECODE(o.type#
,7 ,'PROCEDURE'
,8 ,'FUNCTION'
,9 ,'PACKAGE'
,11 ,'PACKAGE BODY'
,12 ,'TRIGGER'
,13 ,'TYPE'
,14 ,'TYPE BODY'
,'UNDEFINED')
,s.line
,s.source
FROM sys.obj$ o
,sys.source$ s
,sys.user$ u
WHERE o.obj# = s.obj#
AND o.type# IN (7, 8, 9, 11, 12,
13, 14)
AND o.owner# = u.user#
AND u.name LIKE 'FIN%'
UNION ALL
SELECT /*+ ORDERED */
u.name
,o.name
,'JAVA SOURCE'
,s.joxftlno
,s.joxftsrc
FROM sys.obj$ o
,x$joxfs
s
,sys.user$ u
WHERE o.obj# = s.joxftobn
AND o.type# = 28
AND o.owner# = u.user#
AND u.name LIKE 'JAVA%';