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

Lower case table names needs to be active:

MySQL Server needs to be set to:

MySQL :: MySQL 8.4 Reference Manual :: 7.1.8 Server System Variables

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

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