VIEW: SYS.KU$_XSPRIN_VIEW

Source

View Text - Preformatted

select '1','0',
  p.prin#,
  p.type,
  p.guid,
  p.ext_src,
  p.start_date,
  p.end_date,
  p.schema,
  p.tablespace,
  p.profile#,
  p.credential,
  p.failedlogins,
  p.enable,
  p.duration,
  p.system,
  p.scope,
  p.powner,
  p.pname,
  (select pn.name from sys.profname$ pn  where pn.profile#=p.profile#),
  p.objacl#,
  p.note,
  p.status,
  p.ctime,
  p.mtime,
  p.ptime,
  p.exptime,
  p.ltime,
  p.lslogontime,
  p.astatus,
  (select verifier from xs$verifiers where user#=p.prin#),
  (select type# from xs$verifiers where user#=p.prin#),
  p.description
  from xs$prin p

View Text - HTML Formatted

SELECT '1'
, '0'
, P.PRIN#
, P.TYPE
, P.GUID
, P.EXT_SRC
, P.START_DATE
, P.END_DATE
, P.SCHEMA
, P.TABLESPACE
, P.PROFILE#
, P.CREDENTIAL
, P.FAILEDLOGINS
, P.ENABLE
, P.DURATION
, P.SYSTEM
, P.SCOPE
, P.POWNER
, P.PNAME
, (SELECT PN.NAME
FROM SYS.PROFNAME$ PN
WHERE PN.PROFILE#=P.PROFILE#)
, P.OBJACL#
, P.NOTE
, P.STATUS
, P.CTIME
, P.MTIME
, P.PTIME
, P.EXPTIME
, P.LTIME
, P.LSLOGONTIME
, P.ASTATUS
, (SELECT VERIFIER
FROM XS$VERIFIERS
WHERE USER#=P.PRIN#)
, (SELECT TYPE#
FROM XS$VERIFIERS
WHERE USER#=P.PRIN#)
, P.DESCRIPTION
FROM XS$PRIN P