[Home] [Help]
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')
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')
|
|
|
|