...
| Code Block |
|---|
|
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 |
|---|
|
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 |
|---|
|
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)