VIEW: SYS.ALL_DIRECTORIES

Source

View Text - Preformatted

select OWNER, DIRECTORY_NAME, DIRECTORY_PATH, ORIGIN_CON_ID
from INT$DBA_DIRECTORIES
where ( OWNER = SYS_CONTEXT('USERENV', 'CURRENT_USER')
        or OBJ_ID(OWNER, DIRECTORY_NAME, OBJECT_TYPE#, 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 (-177, /* CREATE ANY DIRECTORY */
                                         -178  /* DROP ANY DIRECTORY */)
                  )
      )

View Text - HTML Formatted

SELECT OWNER
, DIRECTORY_NAME
, DIRECTORY_PATH
, ORIGIN_CON_ID FROM INT$DBA_DIRECTORIES WHERE ( OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER') OR OBJ_ID(OWNER
, DIRECTORY_NAME
, OBJECT_TYPE#
, 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 (-177
, /* CREATE ANY DIRECTORY */ -178 /* DROP ANY DIRECTORY */) ) )