VIEW: SYS.ALL_LIBRARIES

Source

View Text - Preformatted

select OWNER, LIBRARY_NAME, FILE_SPEC, DYNAMIC, STATUS, AGENT,
       LEAF_FILENAME, ORIGIN_CON_ID
from   INT$DBA_LIBRARIES
where  (OWNER = SYS_CONTEXT('USERENV', 'CURRENT_USER')
       or OWNER = 'PUBLIC'
       or OBJ_ID(OWNER, LIBRARY_NAME, 22, OBJECT_ID) in
          ( select oa.obj#
            from sys.objauth$ oa
            where grantee# in (select kzsrorol from x$kzsro)
          )
       or (
            exists (select NULL from v$enabledprivs
                    where priv_number in (
                                      -189 /* CREATE ANY LIBRARY */,
                                      -190 /* ALTER ANY LIBRARY */,
                                      -191 /* DROP ANY LIBRARY */,
                                      -192 /* EXECUTE ANY LIBRARY */
                                         )
                   )
          )
      )

View Text - HTML Formatted

SELECT OWNER
, LIBRARY_NAME
, FILE_SPEC
, DYNAMIC
, STATUS
, AGENT
, LEAF_FILENAME
, ORIGIN_CON_ID FROM INT$DBA_LIBRARIES WHERE (OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER') OR OWNER = 'PUBLIC' OR OBJ_ID(OWNER
, LIBRARY_NAME
, 22
, OBJECT_ID) IN ( SELECT OA.OBJ#
FROM SYS.OBJAUTH$ OA
WHERE GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO) ) OR ( EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN ( -189 /* CREATE ANY LIBRARY */
, -190 /* ALTER ANY LIBRARY */
, -191 /* DROP ANY LIBRARY */
, -192 /* EXECUTE ANY LIBRARY */ ) ) ) )