eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_STREAMS_ADMINISTRATOR

Object Details

Object Name:	DBA_STREAMS_ADMINISTRATOR
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Users granted the privileges to be a streams administrator

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
USERNAME	VARCHAR2	(128)	Yes	Name of the user who has been granted privileges to be streams administrator
LOCAL_PRIVILEGES	VARCHAR2	(3)		YES, if user has been granted local Streams admininstrator privileges. NO, if the user does not have local Streams administrator privileges.
ACCESS_FROM_REMOTE	VARCHAR2	(3)		YES, if user can be used for remote Streams administration through a database link. NO, if the user cannot be used for remote Streams administration

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT USERNAME
,      LOCAL_PRIVILEGES
,      ACCESS_FROM_REMOTE
FROM SYS.DBA_STREAMS_ADMINISTRATOR;

Dependencies

[top of page]

SYS.DBA_STREAMS_ADMINISTRATOR references the following:

SYS: USER$; _DBA_STREAMS_PRIVILEGED_USER

SYS.DBA_STREAMS_ADMINISTRATOR is referenced by following:

PUBLIC: DBA_STREAMS_ADMINISTRATOR
SYS: DBMS_LOGREP_UTIL - show dependent code