|Oracle9i Database Reference
Release 2 (9.2)
Part Number A96536-02
DBA_SUBSCRIPTIONS enables publishers to see all subscriptions. You must have the
SELECT_CATALOG_ROLE privilege to access this view. Except for the USERNAME column, which identifies the user name of the subscriber,
DBA_SUBSCRIPTIONS has the same columns as those in "ALL_SUBSCRIPTIONS" .