VIEW: LBACSYS.USER_SA_SESSION

Source

View Text - Preformatted

SELECT p.pol_name AS policy_name,
         sa_session.sa_user_name(p.pol_name)    AS sa_user_name,
         sa_session.privs(p.pol_name)           AS privs,
         sa_session.max_read_label(p.pol_name)  AS max_read_label,
         sa_session.max_write_label(p.pol_name) AS max_write_label,
         sa_session.min_level(p.pol_name)       AS min_level,
         sa_session.label(p.pol_name)           AS label,
         sa_session.comp_write(p.pol_name)      AS comp_write,
         sa_session.group_write(p.pol_name)     AS group_write,
         sa_session.row_label(p.pol_name)       AS row_label
  FROM LBACSYS.ols$pol p
  WHERE p.package='LBAC$SA'

View Text - HTML Formatted

SELECT P.POL_NAME AS POLICY_NAME
, SA_SESSION.SA_USER_NAME(P.POL_NAME) AS SA_USER_NAME
, SA_SESSION.PRIVS(P.POL_NAME) AS PRIVS
, SA_SESSION.MAX_READ_LABEL(P.POL_NAME) AS MAX_READ_LABEL
, SA_SESSION.MAX_WRITE_LABEL(P.POL_NAME) AS MAX_WRITE_LABEL
, SA_SESSION.MIN_LEVEL(P.POL_NAME) AS MIN_LEVEL
, SA_SESSION.LABEL(P.POL_NAME) AS LABEL
, SA_SESSION.COMP_WRITE(P.POL_NAME) AS COMP_WRITE
, SA_SESSION.GROUP_WRITE(P.POL_NAME) AS GROUP_WRITE
, SA_SESSION.ROW_LABEL(P.POL_NAME) AS ROW_LABEL
FROM LBACSYS.OLS$POL P
WHERE P.PACKAGE='LBAC$SA'