Oracle9i Database Reference Release 2 (9.2) Part Number A96536-01 |
|
Static Data Dictionary Views, 134 of 625
ALL_SUBSCRIPTIONS
enables subscribers to view all subscriptions. Neither ALL_SUBSCRIPTIONS
nor USER_SUBSCRIPTIONS
contains the USERNAME
column.
DBA_SUBSCRIPTIONS
enables publishers to view all subscriptions. You must have the SELECT_CATALOG_ROLE
privilege to access this view. DBA_SUBSCRIPTIONS
contains the USERNAME
column, which lists the user name of the subscriber.USER_SUBSCRIPTIONS
enables subscribers to view all of their subscriptions.
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|