Preparing the Database
The following user accounts are recommended for management of the Code Insight database:
|
•
|
DBA or System Administrator with elevated privileges |
|
•
|
Performs backups as necessary |
|
•
|
Code Insight User with Read/Write privileges |
|
•
|
Connects to the database |
|
•
|
Executes database scripts |
|
•
|
Updates the database as necessary |
The following should be performed by a DBA or user with elevated privileges:
|
•
|
Use an existing database or create a new database and schema for use by Code Insight. Below are reference links for proper syntax depending on your database vendor: |
|
•
|
Ensure that the database name conforms to the following guidelines: |
|
•
|
The first character of the database name is alphabetic. |
|
•
|
The database name only contains alphanumeric characters or the _, $, #. |
|
•
|
Do not use dashes (-) in the database name. |
|
•
|
Ensure that the is configured to accept connections from the client machines that Code Insight is using (both core and Scan Servers). This is often done using the GRANT PRIVELEGES command. See the reference manual for your database type for more information. |
|
•
|
Create a Code Insight user with Read/Write privileges. Assign the user to the Code Insight database with a read/write role. |
|
•
|
Start the database. Typically, you can configure the database to run automatically as a service (Windows). |