BUSINESS SOFTWARE, INC. (BSI) CONFIDENTIAL AND PROPRIETARY INFORMATION

Enhanced Security Options

To Remove Enhanced Security Option Features From the Database:

The Windows server comes with scripts to remove enhanced security option features. Run the appropriate script through your database’s online command entry facility as follows:

Note:  After running the appropriate script through you database’s online command entry facility, you must restart the Apache-Tomcat service for the environment being reset.

SQL Server

BSI provides an SQL script to remove enhanced security option features: NOESSQV.SQL. This script is automatically copied to your file system when you install TaxFactory.

To Remove Enhanced Security Option Features on SQL Server:

1. Start the query analyzer for SQL Server.

2. Choose the File menu.

3. Choose Open

4. Select NOESSQV.SQL

5. Click Open. You can now see the contents of the script.

6. Choose the Query menu.

7. Choose Execute.

Oracle

BSI provides a script called NOESORA.SQL to remove enhanced security option features. This script is automatically copied to your file system when you install TaxFactory.

To Remove Enhanced Security Option Features on Oracle:

1. From the Windows Program Manager, choose the Accessories icon.

2. Choose the Notepad icon. Or, you may select your favorite text editor.

3. Choose the File menu.

4. Choose Open.

5. Change directories until you arrive at the directory where TaxFactory (and NOESORA.SQL) is installed.

6. Choose NOESORA.SQL. You now see the contents of the Oracle script.

7. Change all TABLESPACE entries to match your target Oracle table space.

8. Choose the File menu.

9. Choose Save.

10. Exit Notepad.

11. From the Windows Program Manager, choose the Main icon.

12. Choose the Command Prompt icon. You now see a DOS command prompt window.

13. Change directories until you arrive at the directory where TaxFactory (and NOESORA.SQL) is installed.

Type the following:
SQLPLUS userid/password @NOESORA.SQL

where userid is your Oracle user ID and password is your Oracle password.

Informix

BSI provides a script called NOESINF.SQL to remove enhanced security options. This script is automatically copied to your file system when you install TaxFactory.

To Remove Enhanced Security Option Features on Informix:

1. FTP or copy NOESINF.SQL from the Windows directory where the TaxFactory Server software was downloaded to your Informix server directory.

2. Start your Informix environment.

3. Start dbaccess.

4. From the dbaccess menu choose Database.

5. Select your desired database from the list.

6. From the dbaccess menu choose Query-Language.

7. Select Choose from the SQL menu.

8. Select NOESINF.SQL in your server directory.

9. Select Run from the SQL menu.

MySQL

BSI provides a script called NOESSYB.SQL to remove enhanced security options. This script is automatically copied to your file system when you install TaxFactory.

To Remove Enhanced Security Option Features on MySQL:

1. FTP or copy NOESMYS.SQL from the Windows directory where the TaxFactory server software was downloaded to your MySQL server directory.

2. Start your MySQL environment.

3. Change directories until you arrive at the directory where TaxFactory (and NOESMYS.SQL) is installed.
   
   Type the following:
   mysql  -u  TF10   < NOESMYS.SQL
    

DB2

BSI provides a script called NOESSDB2.SQL to remove enhanced security option features. This script is automatically copied to your file system when TaxFactory is installed.

To Remove Enhanced Security Option Features on DB2:

1. FTP or copy NOESDB2.SQL from the Windows directory where the TaxFactory server software was downloaded to your DB2 server directory server directory.

2. Start your DB2 environment.

3. Change directories until you arrive at the directory where TaxFactory (and NOESDB2.SQL) is installed.
   
   Type the following:
   db2  -t  -f   < NOESDB2.SQL
    

iSeries

BSI provides a script called NOES400.SQL to remove enhanced security option features. This script is automatically copied to your file system when TaxFactory is installed.

To Remove Enhanced Security Option Features on DB2 Database, run the following command:

RUNSQLSTM  SRCFILE(TF10/QSQLSTM)  SRCMBR(NOES400)  COMMIT(*CHG)  +
ERRLVL(40) NAMING(*SQL)

MVS

BSI provides a script called NOESSMVS.SQL to remove enhanced security option features. This script is automatically copied to your file system when TaxFactory is installed.

To remove enhanced security option features on MVS/DB2, run the BSI.TF10x.SQL (NOESMVS) script through SPUFI.

HANA

1.     Open the SAP Eclipse Administration Console.

2.    Expand the HANA database in the3 left panel.

3.    Expand Catalog.

4.    Right mouse click on the desired schema.

5.    Select Open SQL Console.

6.    Click File.

7.    Click Open File.

8.    Navigate to NOESHANA.SQL.

9.    Select.

10.  Press Open.

11.  Press RUN.

©Copyright 2021 Business Software, Inc
Unpublished - Rights Reserved Under the Copyright Laws of the United States