Hi!
I'm trying to find an easy way to add new
users/roles/groups to J2 permanently (using HSQL DB
for now). By that I mean that I want to persist newly
created objects in the DB between upgrades of J2.
Currently, when you update and rebuild J2 from CVs,
for example, you have to run the 'maven quickStart'
goal, otherwise none of the web applications
(/jetspeed, etc.) get deployed into the Tomcat.
Unfortunately, this goal also wipes out your DB clean
and you have to re-create all your custom
users/groups/roles...
After going through this (painful, if you have many
users) exercise a few times, I decided to write my own
version of the populate-default-db.sql - kind of
script.
The problem is that I'm not sure what are dependences
between all tables and it was not that easy to find
what tables changed after you add, say, a new user
since you don't really know which tables you should be
monitoring.
Because of that, I have a few questions:
1. could somebody complete my list of tables that have
to be modified when use create custom users and roles
and want to tie them together?
So far I have:
to create a new role:
PREFS_NODE
SECURITY_PRINCIPAL
to create a new user and assign the new role to it:
SECURITY_PRINCIPAL
PRINCIPAL_ROLE_ASSOC
SECURITY_USER_ROLE
SECURITY_USER_GROUP
This actually does not work - I guess I missed a few
tables...
2. Is there a way to save a 'snapshot' of a working DB
with all new objects and use that in a new J2
installation?
3. if all else fails, where is the actual data for the
HSQL DB stored? Maybe I could use some kind of 'diff'
on it after I add a new user ...
Thank you!
Marina
__________________________________
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
