DBA Data[Home] [Help]

VIEW: LBACSYS.ALL_SA_USER_LABELS

Source

View Text - Preformatted

SELECT user_name,
          policy_name,
          user_labels as labels,
          MAX_READ_LABEL,
          MAX_WRITE_LABEL, MIN_WRITE_LABEL ,DEFAULT_READ_LABEL,
          DEFAULT_WRITE_LABEL ,  DEFAULT_ROW_LABEL
     FROM LBACSYS.all_sa_users
    WHERE MAX_READ_LABEL IS NOT NULL
View Text - HTML Formatted

SELECT USER_NAME
, POLICY_NAME
, USER_LABELS AS LABELS
, MAX_READ_LABEL
, MAX_WRITE_LABEL
, MIN_WRITE_LABEL
, DEFAULT_READ_LABEL
, DEFAULT_WRITE_LABEL
, DEFAULT_ROW_LABEL
FROM LBACSYS.ALL_SA_USERS
WHERE MAX_READ_LABEL IS NOT NULL