Permission and Collation requirements for databases

SQL Server

The user with which the application should connect to the database needs the following roles in order to run the database correctly:

USE [<databasename>]
GO
CREATE USER [<username>] FOR LOGIN [<username>]
GO
USE [<databasename>]
GO
ALTER ROLE [db_owner] ADD MEMBER [<username>]
GO

The collation for the database has to be set to SQL_Latin1_General_CP1_CI_AS.

USE [master]
GO
ALTER DATABASE [<database>] COLLATE SQL_Latin1_General_CP1_CI_AS
GO

Oracle Server

The user with which the application should connect to the database needs the following roles in order to run the database correctly:

GRANT CREATE SESSION,ALTER SESSION,CREATE TABLE,CREATE VIEW,CREATE SYNONYM,CREATE PROCEDURE,CREATE SEQUENCE,CREATE MATERIALIZED VIEW,CREATE TRIGGER,CREATE ANY CONTEXT,CREATE JOB,EXECUTE ON SYS.DBMS_LOCK TO <username>;

The collation for the database has to be set to AL32UTF8.

MySQL Server

The user with which the application should connect to the database needs the following roles in order to run the database correctly:

GRANT ALL PRIVILEGES ON <databasename>.* TO '<username>'@'<host>';

The collation for the database has to be set to UTF8:

ALTER SCHEMA `<databasename>`  DEFAULT CHARACTER SET utf8 ;