DBA_STREAMS_ADMINISTRATOR

DBA_STREAMS_ADMINISTRATOR displays information about the users who have been granted privileges to be a Streams administrator by procedures in the DBMS_STREAMS_AUTH package.

Column Datatype NULL Description

USERNAME

VARCHAR2(128)

NOT NULL

Name of the user who has been granted privileges to be a Streams administrator

LOCAL_PRIVILEGES

VARCHAR2(3)

  

Indicates whether the user has been granted local Streams administrator privileges (YES) or not (NO)

ACCESS_FROM_REMOTE

VARCHAR2(3)

  

Indicates whether the user can be used for remote Streams administration through a database link (YES) or not (NO)

See Also:

Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_STREAMS_AUTH package