...
The user with which the application should connect to the database needs the following roles in order to run the database correctly:
Code Block |
---|
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.
Code Block |
---|
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:
Code Block |
---|
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
MySQL Server needs to be set to:
Code Block |
---|
set log_bin_trust_function_creators =1 |
The user with which the application should connect to the database needs the following roles in order to run the database correctly:
Code Block |
---|
GRANT ALL PRIVILEGES ON <databasename>.* TO '<username>'@'<host>'; |
|
The collation for the database has to be set to UTF8:
Code Block |
---|
ALTER SCHEMA `<databasename>` DEFAULT CHARACTER SET utf8 ; |
|