On Jan 22, 2009, at 11:18 PM, Frank Otto wrote:
Thanks for your answer. For generating the database this is a good
way.
But I have another programm with user management. the user I wan't
to use in my jetspeed portal. So if a new user was created, the new
user must be in the jetspeed tables, if the user was deleted, the
user must be droped, If the user ist updated, ... and so one.
Here are the tables. Look here for schemas in Torque format:
http://svn.apache.org/repos/asf/portals/jetspeed-2/portal/tags/JETSPEED-RELEASE-2.1.3/etc/schema/
The SECURITY_PRINCIPAL is the main table containing users and principals
when you build, the target area will contain the DDL specific to your
target database
TABLE
CATEGORY
PROFILING_RULE
PROFILER
RULE_CRITERION
PROFILER
PRINCIPAL_RULE_ASSOC
PROFILER
PROFILE_PAGE_ASSOC
PROFILER
PORTLET_DEFINITION
REGISTRY
PORTLET_APPLICATION
REGISTRY
WEB_APPLICATION
REGISTRY
PA_METADATA_FIELDS
REGISTRY
PD_METADATA_FIELDS
REGISTRY
LANGUAGE
REGISTRY
PORTLET_CONTENT_TYPE
REGISTRY
PARAMETER
REGISTRY
SECURITY_ROLE_REFERENCE
REGISTRY
SECURITY_ROLE
REGISTRY
USER_ATTRIB_REF
REGISTRY
USER_ATTRIBUTE
REGISTRY
JETSPEED_SERVICE
REGISTRY
LOCALIZED_DESCRIPTION
REGISTRY
LOCALIZED_DISPLAY_NAME
REGISTRY
PREFS_PROPERTY_VALUE
PREFERENCES
PREFS_NODE
PREFERENCES
PORTLET_ENTITY
PORTLET WINDOWS
MEDIA_TYPE
CAPABILITIES
CLIENT
CAPABILITIES
MIMETYPE
CAPABILITIES
CAPABILITY
CAPABILITIES
CLIENT_TO_CAPABILITY
CAPABILITIES
CLIENT_TO_MIMETYPE
CAPABILITIES
MEDIATYPE_TO_CAPABILITY
CAPABILITIES
MEDIATYPE_TO_MIMETYPE
CAPABILITIES
PORTLET_STATISTICS
STATISTICS
PAGE_STATISTICS
STATISTICS
USER_STATISTICS
STATISTICS
SECURITY_PRINCIPAL
SECURITY
SECURITY_PERMISSION
SECURITY
PRINCIPAL_PERMISSION
SECURITY
SECURITY_CREDENTIAL
SECURITY
SSO_SITE
SECURITY
SSO_COOKIE
SECURITY
SSO_SITE_TO_PRINCIPALS
SECURITY
SSO_PRINCIPAL_TO_REMOTE
SECURITY
SSO_SITE_TO_REMOTE
SECURITY
SSO_COOKIE_TO_REMOTE
SECURITY
SECURITY_USER_ROLE
SECURITY
SECURITY_USER_GROUP
SECURITY
SECURITY_GROUP_ROLE
SECURITY
OJB_HL_SEQ
OJB
OJB_LOCKENTRY
OJB
OJB_NRM
OJB
OJB_DLIST
OJB
OJB_DLIST_ENTRIES
OJB
OJB_DSET
OJB
FOLDER
PAGE MANAGER
FOLDER_METADATA
PAGE MANAGER
FOLDER_CONSTRAINT
PAGE MANAGER
FOLDER_CONSTRAINTS_REF
PAGE MANAGER
FOLDER_ORDER
PAGE MANAGER
FOLDER_MENU
PAGE MANAGER
FOLDER_MENU_METADATA
PAGE MANAGER
PAGE
PAGE MANAGER
PAGE_METADATA
PAGE MANAGER
PAGE_CONSTRAINT
PAGE MANAGER
PAGE_CONSTRAINTS_REF
PAGE MANAGER
PAGE_MENU
PAGE MANAGER
PAGE_MENU_METADATA
PAGE MANAGER
FRAGMENT
PAGE MANAGER
FRAGMENT_CONSTRAINT
PAGE MANAGER
FRAGMENT_CONSTRAINTS_REF
PAGE MANAGER
FRAGMENT_PREF
PAGE MANAGER
FRAGMENT_PREF_VALUE
PAGE MANAGER
PAGE_SECURITY
PAGE MANAGER
PAGE_SEC_CONSTRAINTS_DEF
PAGE MANAGER
PAGE_SEC_CONSTRAINT_DEF
PAGE MANAGER
PAGE_SEC_CONSTRAINTS_REF
PAGE MANAGER
LINK
PAGE MANAGER
LINK_METADATA
PAGE MANAGER
LINK_CONSTRAINT
PAGE MANAGER
LINK_CONSTRAINTS_REF
PAGE MANAGER
