Manually loading stored procedures during site creation - SmartPlant Foundation - Update 22 - Installation & Upgrade

Manual Site Application Pool Setup

Language
English
Product
SmartPlant Foundation
Search by Category
Installation & Upgrade
SmartPlant Foundation / SDx Version
10

When creating a new primary site, to load stored procedures for creating Data Validator tables in the database, you can check the Load Stored Procedures to create or update the tables or indexes in the database check box to load the stored procedures located at [drive]:\ Program Files (x86)\[Product Folder]\SPFServerManager\DatabaseScripts\Stored Procedures\[DB Type].

However, if you want to load the stored procedures manually, follow these procedures.

Each SmartPlant Foundation database user must have create table access granted by the system administrator.

For example, when using an Oracle database, connect to the database as the system administrator and execute the following SQL statement:

grant create table to vtl_data;