DBA Data[Home] [Help]

VIEW: SYSTEM.PRODUCT_PRIVS

Source

View Text - Preformatted

select product, userid, attribute, scope,
         numeric_value, char_value, date_value, long_value
  from sqlplus_product_profile
  where userid = 'PUBLIC' or user like userid
View Text - HTML Formatted

SELECT PRODUCT
, USERID
, ATTRIBUTE
, SCOPE
, NUMERIC_VALUE
, CHAR_VALUE
, DATE_VALUE
, LONG_VALUE
FROM SQLPLUS_PRODUCT_PROFILE
WHERE USERID = 'PUBLIC' OR USER LIKE USERID