Reload Security Scripts

There are three instances when security scripts need to be reloaded.  First, when the build manager performs the initial install of OIPA and Rules Palette, the security scripts should be reloaded.  Then, when a new company is created in the Rules Palette, the security scripts must be reloaded so that the new company can access the Web Services.  Finally, if a company is deleted through the database, these scripts should also be reloaded.  

Each type of database will need its own security script.  

• SQL Server

• Oracle

• DB2

Once the security script has been reloaded, all companies will have access to all Web Services.

Note:  There is a table called AsAuthWebService, which is automatically populated with the Web Service definitions needed to associate Web Services to Companies.  If you need to re-run the Web Services definitions for any reason, refer to the Re-Run Web Service Definitions section below.  Make sure to use the script that corresponds to the type of database you are using.

 Run Security Scripts for SQL Server Database

1. Open your database query software.

2. Type delete * from AsAuthCompanyWebService and execute the query to delete all records from the AsAuthCompanyWebService table.  

3. Type the following query as shown below and then execute the query.

INSERT INTO AsAuthCompanyWebService

SELECT AuthCompanyGUID, AuthWebService.AuthWebServiceGUID

  FROM AsAuthCompany,

       (SELECT '7B629464-31DE-4A2C-B415-F9BD45F492FA' AS AuthWebServiceGUID

         UNION ALL

        SELECT '5ADC18E4-D752-4D3D-BEFE-5AA626210768' AS AuthWebServiceGUID

         UNION ALL

        SELECT '5007146B-326D-447C-B11B-F1A9CD7489B2' AS AuthWebServiceGUID

         UNION ALL

        SELECT 'FD913858-B77A-40B1-9B6A-71E1191AA807' AS AuthWebServiceGUID) AuthWebService

GO

Note:  If you cannot access a Web Service after reloading security scripts, re-run your Web Service definitions to make sure the Web Services you are referencing in the security scripts are the same ones in your database.

Run Security Scripts for Oracle Database

1. Open your database query software.

2. Type delete * from AsAuthCompanyWebService and execute the query to delete all records from the AsAuthCompanyWebService table.  

3. Type the following query as shown below and then execute the query.

INSERT INTO AsAuthCompanyWebService

SELECT AuthCompanyGUID, AuthWebService.AuthWebServiceGUID

  FROM AsAuthCompany,

       (SELECT '7B629464-31DE-4A2C-B415-F9BD45F492FA' AS AuthWebServiceGUID FROM DUAL

         UNION ALL

        SELECT '5ADC18E4-D752-4D3D-BEFE-5AA626210768' AS AuthWebServiceGUID FROM DUAL

         UNION ALL

        SELECT '5007146B-326D-447C-B11B-F1A9CD7489B2' AS AuthWebServiceGUID FROM DUAL

         UNION ALL

        SELECT 'FD913858-B77A-40B1-9B6A-71E1191AA807' AS AuthWebServiceGUID FROM DUAL ) AuthWebService

GO

Note:  If you cannot access a Web Service after reloading security scripts, re-run your Web Service definitions to make sure the Web Services you are referencing in the security scripts are the same ones in your database.

Run Security Scripts for DB2 Database

1. Open your database query software.

2. Type delete * from AsAuthCompanyWebService and execute the query to delete all records from the AsAuthCompanyWebService table.  

3. Type the following query as shown below and then execute the query.

INSERT INTO AsAuthCompanyWebService

SELECT AuthCompanyGUID, AuthWebService.AuthWebServiceGUID

  FROM AsAuthCompany,

       (SELECT '7B629464-31DE-4A2C-B415-F9BD45F492FA' AS AuthWebServiceGUID FROM SYSIBM.SYSDUMMY1

         UNION ALL

        SELECT '5ADC18E4-D752-4D3D-BEFE-5AA626210768' AS AuthWebServiceGUID FROM SYSIBM.SYSDUMMY1

         UNION ALL

        SELECT '5007146B-326D-447C-B11B-F1A9CD7489B2' AS AuthWebServiceGUID FROM SYSIBM.SYSDUMMY1

         UNION ALL

        SELECT 'FD913858-B77A-40B1-9B6A-71E1191AA807' AS AuthWebServiceGUID FROM SYSIBM.SYSDUMMY1 ) AuthWebService

GO

Note:  If you cannot access a Web Service after reloading security scripts, re-run your Web Service definitions to make sure the Web Services you are referencing in the security scripts are the same ones in your database.

Re-run Web Service Definitions for SQL

1. Open your database query software.

2. Type the following query as shown below and then execute the query.

INSERT INTO AsAuthWebService (AuthWebServiceGUID, WebServiceName)

SELECT '7B629464-31DE-4A2C-B415-F9BD45F492FA' AS AuthWebServiceGUID, 'FileReceived' AS WebServiceName

   UNION ALL

SELECT '5ADC18E4-D752-4D3D-BEFE-5AA626210768' AS AuthWebServiceGUID, 'InputRequest' AS WebServiceName

   UNION ALL

SELECT '5007146B-326D-447C-B11B-F1A9CD7489B2' AS AuthWebServiceGUID, 'DebuggerService' AS WebServiceName

   UNION ALL

SELECT 'FD913858-B77A-40B1-9B6A-71E1191AA807' AS AuthWebServiceGUID, 'ExposedComputation' AS WebServiceName

GO

Re-run Web Service Definitions for Oracle

1. Open your database query software.

2. Type the following query as shown below and then execute the query.

INSERT INTO AsAuthWebService (AuthWebServiceGUID, WebServiceName)

SELECT '7B629464-31DE-4A2C-B415-F9BD45F492FA' AS AuthWebServiceGUID, 'FileReceived' AS WebServiceName FROM DUAL

    UNION ALL

SELECT '5ADC18E4-D752-4D3D-BEFE-5AA626210768' AS AuthWebServiceGUID, 'InputRequest' AS WebServiceName FROM DUAL

    UNION ALL

SELECT '5007146B-326D-447C-B11B-F1A9CD7489B2' AS AuthWebServiceGUID, 'DebuggerService' AS WebServiceName FROM DUAL

    UNION ALL

SELECT 'FD913858-B77A-40B1-9B6A-71E1191AA807' AS AuthWebServiceGUID, 'ExposedComputation' AS WebServiceName FROM DUAL

GO

Re-run Web Service Definitions for DB2

1. Open your database query software.

2. Type the following query as shown below and then execute the query.

INSERT INTO AsAuthWebService (AuthWebServiceGUID, WebServiceName)

SELECT '7B629464-31DE-4A2C-B415-F9BD45F492FA' AS AuthWebServiceGUID, 'FileReceived' AS WebServiceName FROM SYSIBM.SYSDUMMY1

    UNION ALL

SELECT '5ADC18E4-D752-4D3D-BEFE-5AA626210768' AS AuthWebServiceGUID, 'InputRequest' AS WebServiceName FROM SYSIBM.SYSDUMMY1

    UNION ALL

SELECT '5007146B-326D-447C-B11B-F1A9CD7489B2' AS AuthWebServiceGUID, 'DebuggerService' AS WebServiceName FROM SYSIBM.SYSDUMMY1

    UNION ALL

SELECT 'FD913858-B77A-40B1-9B6A-71E1191AA807' AS AuthWebServiceGUID, 'ExposedComputation' AS WebServiceName FROM SYSIBM.SYSDUMMY1

GO