Attached is the sql file I'm using, I'm pretty sure I have everything...
I'm doing inserts into turbine_role, turbine_user, turbine_user_group_role, and turbine_role_permission (phew!)
I've been tearing my hair out over this one all day, anything you could do to help will be greatly appreciated. Meanwhile, I'll go read through the flux code (again!!!)
Regards,
Matt
-- ____ | Matthew J. Forder | Data Center Supervisor / / () | Seagate Techology | Tel:+31 20 316 7468 \ \ \ | Koolhovenlaan 1 | Fax:+31 20 653 5537 ()_/_/ | 1119 NB Schiphol-Rijk, NL | [EMAIL PROTECTED]
/* Script to fill the tables with default roles and permissions */
/* Create the global group */
/* this group is used to assign system-wide roles to users */
INSERT INTO TURBINE_ROLE (ROLE_ID, ROLE_NAME) VALUES (10, 'cqd_user');
INSERT INTO TURBINE_ROLE (ROLE_ID, ROLE_NAME) VALUES (11, 'cqd_admin');
/* Create an account, cqdadmin, for application administartor */
INSERT INTO TURBINE_USER
(USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME)
VALUES
(10, 'cqdadmin', 'cqdamdin', 'cqdamdin', 'cqdamdin');
/* Assign the user, cqdadmin, a system-wide role, cqd_admin */
INSERT INTO TURBINE_USER_GROUP_ROLE ( USER_ID, GROUP_ID, ROLE_ID )
SELECT TURBINE_USER.USER_ID, TURBINE_GROUP.GROUP_ID, TURBINE_ROLE.ROLE_ID from
TURBINE_USER, TURBINE_GROUP, TURBINE_ROLE
WHERE TURBINE_USER.LOGIN_NAME = 'cqdadmin' AND
TURBINE_GROUP.GROUP_NAME = 'global' AND TURBINE_ROLE.ROLE_NAME = 'cqd_admin';
/* Assign the user, cqdadmin, a system-wide role, cqd_user */
INSERT INTO TURBINE_USER_GROUP_ROLE ( USER_ID, GROUP_ID, ROLE_ID )
SELECT TURBINE_USER.USER_ID, TURBINE_GROUP.GROUP_ID, TURBINE_ROLE.ROLE_ID from
TURBINE_USER, TURBINE_GROUP, TURBINE_ROLE
WHERE TURBINE_USER.LOGIN_NAME = 'cqdadmin' AND
TURBINE_GROUP.GROUP_NAME = 'global' AND TURBINE_ROLE.ROLE_NAME = 'cqd_user';
/* Add some permissions for the cqd_admin role */
INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID)
SELECT TURBINE_ROLE.ROLE_ID, TURBINE_PERMISSION.PERMISSION_ID FROM
TURBINE_ROLE, TURBINE_PERMISSION
WHERE TURBINE_PERMISSION.PERMISSION_NAME = 'admin_users' AND
TURBINE_ROLE.ROLE_NAME = 'cqd_admin';
/* Add some permissions for the cqd_user role */
INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID)
SELECT TURBINE_ROLE.ROLE_ID, TURBINE_PERMISSION.PERMISSION_ID FROM
TURBINE_ROLE, TURBINE_PERMISSION
WHERE TURBINE_PERMISSION.PERMISSION_NAME = 'admin_users' AND
TURBINE_ROLE.ROLE_NAME = 'cqd_user';
begin:vcard n:Forder;Matthew tel;cell:+31 65 350 8743 tel;fax:+31 20 653 5537 tel;work:+31 20 316 7468 x-mozilla-html:TRUE url:http://www.seagate.com/ org:<i>Seagate Technology LLC</i>;<a href="http://www.seagate.com/";><img src="http://www.seagate.com/images/doors/frontdoor/logo.gif"; width=99 height=24 border=0 vspace=3 alt="Seagate" align=right></a> adr:;;Koolhovenlaan 1;Schiphol-Rijk;North Holland;1119 NB;Netherlands version:2.1 email;internet:[EMAIL PROTECTED] title:<b>Datacenter Supervisor</b> x-mozilla-cpt:;-25048 fn:Matthew Forder end:vcard
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
![http://www.seagate.com/images/doors/frontdoor/logo.gif"](http://www.seagate.com/images/doors/frontdoor/logo.gif"){kind=link}