VIEW: SYS.USER_ASSEMBLIES

Source

View Text - Preformatted

select o.name,
       a.filespec,
       decode(a.security_level, 0, 'SAFE', 1, 'EXTERNAL_1', 2, 'EXTERNAL_2',
                                3, 'EXTERNAL_3', 4, 'UNSAFE'),
       a.identity,
       decode(o.status, 0, 'N/A', 1, 'VALID', 'INVALID')
from sys."_CURRENT_EDITION_OBJ" o, sys.assembly$ a
where o.owner# = userenv('SCHEMAID')
  and o.obj# = a.obj#

View Text - HTML Formatted

SELECT O.NAME
, A.FILESPEC
, DECODE(A.SECURITY_LEVEL
, 0
, 'SAFE'
, 1
, 'EXTERNAL_1'
, 2
, 'EXTERNAL_2'
, 3
, 'EXTERNAL_3'
, 4
, 'UNSAFE')
, A.IDENTITY
, DECODE(O.STATUS
, 0
, 'N/A'
, 1
, 'VALID'
, 'INVALID') FROM SYS."_CURRENT_EDITION_OBJ" O
, SYS.ASSEMBLY$ A WHERE O.OWNER# = USERENV('SCHEMAID')
AND O.OBJ# = A.OBJ#