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]

TABLE: XDB.APP_USERS_AND_ROLES

Object Details

Object Name:	APP_USERS_AND_ROLES
Object Type:	TABLE
Owner:	XDB
Subobject Name:
Status:	VALID

Application users and roles/workspaces

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Unique Key: SYS_C00241278

NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00241278	NORMAL	UNIQUE	SYSAUX	NAME

Columns

Name	Datatype	Length	Comments
GUID	RAW	(16)	The GUID for user or role/workgroup
NAME	VARCHAR2	(1024)	The name of user or role/workgroup
ISROLE	VARCHAR2	(3)	Whether user or role/workgroup

Query Text

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


SELECT GUID
,      NAME
,      ISROLE
FROM XDB.APP_USERS_AND_ROLES;

Dependencies

[top of page]

XDB.APP_USERS_AND_ROLES does not reference any database object

XDB.APP_USERS_AND_ROLES is not referenced by any database object