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: SYSTEM.PRODUCT_PRIVS

Object Details

Object Name:	PRODUCT_PRIVS
Object Type:	VIEW
Owner:	SYSTEM
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PRODUCT	VARCHAR2	(30)	Yes
USERID	VARCHAR2	(30)
ATTRIBUTE	VARCHAR2	(240)
SCOPE	VARCHAR2	(240)
NUMERIC_VALUE	NUMBER	(15)
CHAR_VALUE	VARCHAR2	(240)
DATE_VALUE	DATE
LONG_VALUE	LONG	(0)

Query Text

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


SELECT PRODUCT
,      USERID
,      ATTRIBUTE
,      SCOPE
,      NUMERIC_VALUE
,      CHAR_VALUE
,      DATE_VALUE
,      LONG_VALUE
FROM SYSTEM.PRODUCT_PRIVS;

Dependencies

[top of page]

SYSTEM.PRODUCT_PRIVS references the following:

SYSTEM: SQLPLUS_PRODUCT_PROFILE

SYSTEM.PRODUCT_PRIVS is referenced by following:

PUBLIC: PRODUCT_PROFILE; PRODUCT_USER_PROFILE