DBA Data[Home] [Help]
Skip to content

VIEW: LBACSYS.DBA_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.dba_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.DBA_SA_USERS
WHERE MAX_READ_LABEL IS NOT NULL