Reference Guide > TDV and Business Directory System Tables > ALL_RESOURCES
 
ALL_RESOURCES
The ALL_RESOURCES system table exposes all TDV resources to which the current user has access.
Users cannot see any rows from this table unless they have the ACCESS_TOOLS right. All resources are shown for administrators with the READ_ALL_RESOURCES right. Users without the READ_ALL_RESOURCES right can view resource rows in the system table for which they have read privileges both on the resource and on all parent nodes of that resource.
For performance reasons, column and parameter metadata are not returned.
Column
TDV
JDBC Data Type
Nullable
Description
RESOURCE_ID
INTEGER
 
Identifier of the resource. Primary key.
RESOURCE_NAME
VARCHAR(255)
 
Name of the resource.
RESOURCE_TYPE
VARCHAR(255)
 
Type of the resource.
ANNOTATION
VARCHAR(65535)
Yes
Annotation for the resource.
DEFINITION
VARCHAR(16777215)
Yes
Definition of the resource. Applicable only to certain resources such as SQL Scripts, packaged queries, XSLT-based transformations.
OWNER_ID
INTEGER
 
Identifier of the user who created or owns the data source.
OWNER
VARCHAR(60)
 
User name of the person that owns/created the data source.
PARENT_PATH
VARCHAR(65535)
 
Path to the parent container.
GUID
VARCHAR(65535)
 
Nearly unique 128-bit identifier.
RESOURCE_SUBTYPE
VARCHAR(255)
 
Subtype of the resource.