VIEW: SYS.KU$_DBLINK_VIEW

Source

View Text - Preformatted

select '1','1',
         u.name,
         l.owner#, l.name, to_char(l.ctime,'YYYY/MM/DD HH24:MI:SS'),
         l.host, l.userid,
         l.password, l.flag, l.authusr, l.authpwd,
         dbms_metadata_util.glo(l.passwordx),dbms_metadata_util.glo(l.authpwdx)
  from   sys.user$ u, sys.link$ l
  where  u.user# = l.owner#
     AND (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (u.user#, 0) OR
          EXISTS ( SELECT * FROM sys.session_roles
                   WHERE role='EXP_FULL_DATABASE' ))
UNION
  select '1','1',
         u.name,
         l.owner#, l.name, to_char(l.ctime,'YYYY/MM/DD HH24:MI:SS'),
         l.host, l.userid,
         NULL, l.flag, l.authusr, NULL,
         NULL, NULL
  from   sys.user$ u, sys.link$ l
  where  u.user# = l.owner#
     AND (SYS_CONTEXT('USERENV','CURRENT_USERID') NOT IN (u.user#, 0))
     AND NOT (EXISTS ( SELECT * FROM sys.session_roles
                   WHERE role='EXP_FULL_DATABASE' ))
     AND (EXISTS ( SELECT * FROM sys.session_roles
                   WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '1'
, U.NAME
, L.OWNER#
, L.NAME
, TO_CHAR(L.CTIME
, 'YYYY/MM/DD HH24:MI:SS')
, L.HOST
, L.USERID
, L.PASSWORD
, L.FLAG
, L.AUTHUSR
, L.AUTHPWD
, DBMS_METADATA_UTIL.GLO(L.PASSWORDX)
, DBMS_METADATA_UTIL.GLO(L.AUTHPWDX)
FROM SYS.USER$ U
, SYS.LINK$ L
WHERE U.USER# = L.OWNER#
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (U.USER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='EXP_FULL_DATABASE' )) UNION SELECT '1'
, '1'
, U.NAME
, L.OWNER#
, L.NAME
, TO_CHAR(L.CTIME
, 'YYYY/MM/DD HH24:MI:SS')
, L.HOST
, L.USERID
, NULL
, L.FLAG
, L.AUTHUSR
, NULL
, NULL
, NULL
FROM SYS.USER$ U
, SYS.LINK$ L
WHERE U.USER# = L.OWNER#
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') NOT IN (U.USER#
, 0))
AND NOT (EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='EXP_FULL_DATABASE' ))
AND (EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))