At other times, during routine DSN use, the SQL Server connection need only have read and update permissions to SYSIBM, assuming that the SYSIBM owner has update permissions for the tables in the SYSIBM schema.
Each time you execute DSN, it automatically evaluates the need for schema creation and maintenance, which is necessary immediately after the creation of the SQL Server database, and immediately after an HCOSS upgrade. In these cases, it executes the following SQL scripts that require create permissions:
- InstallSYSIBM.sql to create the SYSIBM schema and install its appropriate tables
- InstallBindProcs.sql to create appropriate stored procedures in the SYSIBM schema
- InstallDigitsFunction.sql to create appropriate user-defined functions in the dbo schema
You can prevent DSN from executing these SQL scripts by executing them manually immediately after creating your SQL Server database and immediately after performing an HCOSS upgrade. All three script files reside in your
%ProgramData%\Micro Focus\NetExpress\6.0 directory.
