Knowledgebase

Search:     Advanced search

Changing the Schema Used to Create Tables in SQL Server

Article ID: 707  |  Last updated: 23 Dec, 2014

Note: This information only applies to Surround SCM 2010.0.1 and later.

To create the Surround SCM tables in a SQL Server database, the database user must have the dbo schema. Use the following steps to create and use a schema other than dbo. Replace references to SchemaUser and SchemaName with the username and schema name you want to use

  1. Create a new SQL Server database.
  2. Run the following commands in the new database.

    CREATE LOGIN SchemaUser WITH PASSWORD = ‘password’;
    GO

    CREATE SCHEMA SchemaName;
    GO

    CREATE USER SchemaUser  FOR LOGIN SchemaUser WITH DEFAULT_SCHEMA = SchemaName;
    GO

    GRANT CREATE TABLE TO SchemaUser;
    GRANT CREATE PROCEDURE TO SchemaUser;
    GRANT CREATE VIEW TO SchemaUser;

    GRANT CONTROL ON SCHEMA :: SchemaName TO SchemaUser
    GO
  3. In SQL Server Management Studio, make sure the SchemaUser user has the db_ddladmin permission.

Note: Use the SchemaUser and password and the default database when you create the ODBC connection. You also need to use the SchemaUser and password when you create the SQL Server connection during Surround SCM installation.

Article ID: 707  |   Last updated: 23 Dec, 2014
Tags
database SQL Server schema

Prev   Next
Cannot Load the Surround SCM Java API Library on Linux     GCC Library Cannot be Found on Linux