Which database user should run the createJawsDB.sql query when installing the AAI database schema?

Products

• Automation Analytics & Intelligence

Issue/Introduction

For the AAI installation, one of the post installation step is to create the DB by running the two files: createDevices.sql and createJawsDB.sql.

Which database user should run the createJawsDB.sql query when installing the AAI database schema?

Environment

Release : 6.4.6.2

Resolution

The createJawsDB.sql should be run by the database user that will own the AAI schema.

 

In the CreateDevices.sql there is a line for creating the user, that is the user that should run the createJawsDB.sql.

 

This will also be the user you use to connect AAI to the database.