Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagehtml/xml
CREATE USER suncode WITH encrypted password 'haslo123';
CREATE DATABASE "PWFL";
GRANT ALL PRIVILEGES ON DATABASE "PWFL" TO suncode;

Microsoft SQLServer

Note

Uwaga: Baza musi być skonfigurowana jako CI_AI (case insensitive + accent sensitive)

Minimalne uprawnienia użytkownika bazodanowego

Code Block
languagehtml/xml
USE [master]
GO
CREATE LOGIN suncode WITH PASSWORD = "haslo123";
GO
CREATE DATABASE [PWFL] COLLATE Polish_CI_AI;
GO
USE [PWFL]
GO
CREATE USER suncode FOR LOGIN suncode;
GO
EXEC sp_addrolemember  "db_owner", "suncode";

 

Oracle

Minimalne uprawnienia użytkownika bazodanowego

Code Block
languagehtml/xml
CREATE USER SUNCODE IDENTIFIED BY "haslo123";
GRANT CONNECT, RESOURCE TO SUNCODE;
GRANT UNLIMITED TABLESPACE TO SUNCODE;

Uwaga: Baza musi być skonfigurowana jako CI_AI (case insensitive + accent sensitive)