VIEW: SYS._ALL_FILE_GROUPS

Source

View Text - Preformatted

select g.file_group_id, u.name, o.name, g.keep_files, g.min_versions,
       g.max_versions, g.retention_days, g.creation_time, g.user_comment,
       g.default_dir_obj, g.creator
from sys.obj$ o, sys.user$ u, sys.fgr$_file_groups g
where o.owner# = u.user# and o.obj# = g.file_group_id and
      (o.owner# in (USERENV('SCHEMAID'), 1 /* PUBLIC */) or
       o.obj# 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 (
                                                         -277, -278)))

View Text - HTML Formatted

SELECT G.FILE_GROUP_ID
, U.NAME
, O.NAME
, G.KEEP_FILES
, G.MIN_VERSIONS
, G.MAX_VERSIONS
, G.RETENTION_DAYS
, G.CREATION_TIME
, G.USER_COMMENT
, G.DEFAULT_DIR_OBJ
, G.CREATOR FROM SYS.OBJ$ O
, SYS.USER$ U
, SYS.FGR$_FILE_GROUPS G WHERE O.OWNER# = U.USER#
AND O.OBJ# = G.FILE_GROUP_ID AND (O.OWNER# IN (USERENV('SCHEMAID')
, 1 /* PUBLIC */) OR O.OBJ# 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 ( -277
, -278)))