DBA Data[Home] [Help]
Skip to content

VIEW: SYS.USER_XDS_ACL_REFRESH

Source

View Text - Preformatted

select s.schema_name,
          s.table_name,
          s.acl_mview_name,
          s.refresh_mode,
          s.refresh_ability,
          s.acl_status,
          s.user_supplied_mv,
          s.start_date,
          s.repeat_interval,
          s.refresh_count,
          s.comments
from dba_xds_acl_refresh s, sys.user$ u
where s.schema_name = u.name
  and u.user# = userenv('SCHEMAID')
View Text - HTML Formatted

SELECT S.SCHEMA_NAME
, S.TABLE_NAME
, S.ACL_MVIEW_NAME
, S.REFRESH_MODE
, S.REFRESH_ABILITY
, S.ACL_STATUS
, S.USER_SUPPLIED_MV
, S.START_DATE
, S.REPEAT_INTERVAL
, S.REFRESH_COUNT
, S.COMMENTS FROM DBA_XDS_ACL_REFRESH S
, SYS.USER$ U WHERE S.SCHEMA_NAME = U.NAME
AND U.USER# = USERENV('SCHEMAID')