to insert in the TURBINE_USER table the value for USERID must be set ... here my oracle_default_role_permissions.sql // ======================================================== -- Script to fill the tables with default roles and permissions (Oracle only!) -- Create the global group -- this group is used to assign system-wide roles to users insert into TURBINE_GROUP (GROUPID, GROUPNAME) values (1,'global'); -- Create the root role insert into TURBINE_ROLE (ROLEID, ROLENAME) values (1, 'turbine_root'); -- Create an account 'turbine' for system administartor -- Remeber to set a good password for this user in a production system! insert into TURBINE_USER (USERID, LOGINID, PASSWORD_VALUE, FIRST_NAME, LAST_NAME) values (TURBINE_USER_SEQ.NEXTVAL, 'turbine', 'turbine', 'turbine', 'turbine'); -- Assign the user 'turbine' a system-wide role 'turbine_root' insert into TURBINE_USER_GROUP_ROLE ( USERID, GROUPID, ROLEID ) select TURBINE_USER.USERID, TURBINE_GROUP.GROUPID, TURBINE_ROLE.ROLEID from TURBINE_USER, TURBINE_GROUP, TURBINE_ROLE where TURBINE_USER.LOGINID = 'turbine' AND TURBINE_GROUP.GROUPNAME = 'global' AND TURBINE_ROLE.ROLENAME = 'turbine_root'; -- Add some default permissions insert into TURBINE_PERMISSION (PERMISSIONID, PERMISSION) values (1, 'admin_users'); -- Add some permissions for the root role insert into TURBINE_ROLE_PERMISSION (ROLEID,PERMISSIONID) select TURBINE_ROLE.ROLEID, TURBINE_PERMISSION.PERMISSIONID from TURBINE_ROLE, TURBINE_PERMISSION where TURBINE_PERMISSION.PERMISSION = 'admin_users' and TURBINE_ROLE.ROLENAME = 'turbine_root'; ------------------------------------------------------------ To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/> Problems?: [EMAIL PROTECTED]
