Assigning the Optiva database user to the Optiva database schema

Creating the Optiva database user gives that user access to the database server. To grant access to the Optiva database schema:

  1. Connect to the SQL Server Management Studio with an account having System Administrator privileges.
  2. Select an Optiva Database. Under that database, select Security > Users.
  3. Select New User from the shortcut menu.
  4. Specify this information:
    Login Name
    Specify the Optiva user that was created in the previous section.
    Database role membership region
    Select the check boxes for db_ddladmin, db_datareader, and db_datawriter.
  5. Click OK to assign the Optiva database user to the Optiva database with the selected roles.
    After you restore the Optiva database schema from the backup file, create the Optiva user. Then, assign the Optiva user to the Optiva database with the appropriate permissions. The Optiva database is ready for use with the Optiva application server.