[prev in list] [next in list] [prev in thread] [next in thread] 

List:       jserv-dev
Subject:    CVS update: turbine/src/sql db2-turbine-security.sql
From:       Java Apache CVS Development <jon () clearink ! com>
Date:       2000-12-29 4:04:20
[Download RAW message or body]

  User: jvanzyl 
  Date: 00/12/28 20:04:20

  Modified:    src/sql  db2-turbine-security.sql
                        interbase-turbine-security.sql
  Log:
  - added turbine security code for db2 and interbase.
  
  Revision  Changes    Path
  1.2       +60 -0     turbine/src/sql/db2-turbine-security.sql
  
  Index: db2-turbine-security.sql
  ===================================================================
  RCS file: /products/cvs/turbine/turbine/src/sql/db2-turbine-security.sql,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- db2-turbine-security.sql	2000/12/28 20:50:04	1.1
  +++ db2-turbine-security.sql	2000/12/29 04:04:19	1.2
  @@ -1,2 +1,62 @@
  +---------------------------------------------------------------------------
  +-- Script to fill the tables with default roles and permissions
  +-- Currently tested with MySQL, Oracle, Postgres and Hypersonic only.
  +---------------------------------------------------------------------------
   
  +---------------------------------------------------------------------------
  +-- Create the global group
  +-- this group is used to assign system-wide roles to users
  +---------------------------------------------------------------------------
  +
  +INSERT INTO TURBINE_GROUP (GROUP_ID, GROUP_NAME) VALUES (1,'global');
  +
  +---------------------------------------------------------------------------
  +-- Create the root role
  +---------------------------------------------------------------------------
  +
  +INSERT INTO TURBINE_ROLE (ROLE_ID, ROLE_NAME) 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 
  +    (LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME) 
  +    VALUES
  +    ('turbine', 'turbine', 'turbine', 'turbine');
  +
  +---------------------------------------------------------------------------
  +-- Assign the user 'turbine' a system-wide role 'turbine_root'
  +---------------------------------------------------------------------------
  +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 = 'turbine' AND 
  +TURBINE_GROUP.GROUP_NAME = 'global' AND TURBINE_ROLE.ROLE_NAME = 'turbine_root';
  +
  +---------------------------------------------------------------------------
  +-- Add some default permissions
  +---------------------------------------------------------------------------
  +
  +INSERT INTO TURBINE_PERMISSION 
  +    (PERMISSION_ID, PERMISSION_NAME) 
  +    VALUES 
  +    (1, 'admin_users');
  +
  +---------------------------------------------------------------------------
  +-- Add some permissions for the root 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 = 'turbine_root';
  +
  +-- Use this script to bootstrap you system into usage of secure passwords.
  +-- It will set the administrator's password to 'turbine' (using SHA digest)
  +-- Then, you'll be able to log in and change administrator's passwords,
  +-- and then set initial passwords for your users.
  +
  +UPDATE TURBINE_USER SET PASSWORD_VALUE = '4vUZ7HvhmiKt/W54Xyuz7oza' WHERE LOGIN_NAME = 'turbine';
   
  
  
  
  1.2       +60 -0     turbine/src/sql/interbase-turbine-security.sql
  
  Index: interbase-turbine-security.sql
  ===================================================================
  RCS file: /products/cvs/turbine/turbine/src/sql/interbase-turbine-security.sql,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- interbase-turbine-security.sql	2000/12/28 20:50:06	1.1
  +++ interbase-turbine-security.sql	2000/12/29 04:04:20	1.2
  @@ -1,2 +1,62 @@
  +---------------------------------------------------------------------------
  +-- Script to fill the tables with default roles and permissions
  +-- Currently tested with MySQL, Oracle, Postgres and Hypersonic only.
  +---------------------------------------------------------------------------
   
  +---------------------------------------------------------------------------
  +-- Create the global group
  +-- this group is used to assign system-wide roles to users
  +---------------------------------------------------------------------------
  +
  +INSERT INTO TURBINE_GROUP (GROUP_ID, GROUP_NAME) VALUES (1,'global');
  +
  +---------------------------------------------------------------------------
  +-- Create the root role
  +---------------------------------------------------------------------------
  +
  +INSERT INTO TURBINE_ROLE (ROLE_ID, ROLE_NAME) 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 
  +    (LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME) 
  +    VALUES
  +    ('turbine', 'turbine', 'turbine', 'turbine');
  +
  +---------------------------------------------------------------------------
  +-- Assign the user 'turbine' a system-wide role 'turbine_root'
  +---------------------------------------------------------------------------
  +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 = 'turbine' AND 
  +TURBINE_GROUP.GROUP_NAME = 'global' AND TURBINE_ROLE.ROLE_NAME = 'turbine_root';
  +
  +---------------------------------------------------------------------------
  +-- Add some default permissions
  +---------------------------------------------------------------------------
  +
  +INSERT INTO TURBINE_PERMISSION 
  +    (PERMISSION_ID, PERMISSION_NAME) 
  +    VALUES 
  +    (1, 'admin_users');
  +
  +---------------------------------------------------------------------------
  +-- Add some permissions for the root 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 = 'turbine_root';
  +
  +-- Use this script to bootstrap you system into usage of secure passwords.
  +-- It will set the administrator's password to 'turbine' (using SHA digest)
  +-- Then, you'll be able to log in and change administrator's passwords,
  +-- and then set initial passwords for your users.
  +
  +UPDATE TURBINE_USER SET PASSWORD_VALUE = '4vUZ7HvhmiKt/W54Xyuz7oza' WHERE LOGIN_NAME = 'turbine';
   
  
  
  

[prev in list] [next in list] [prev in thread] [next in thread]